grant connect to %user;
grant resource to %user;

begin
  execute immediate('grant owb_d_' || user || ' to %user');
end;
/
commit;