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

grant alter session to %user;
grant unlimited tablespace to %user;
grant create any type to %user;
grant create database link to %user;
grant create public database link to %user;
grant create dimension to %user;
grant create indextype to %user;
grant create procedure to %user;
grant create public synonym to %user;
grant drop public synonym to %user;
grant create sequence to %user;
grant create session to %user;
grant create snapshot to %user;
grant create synonym to %user;
grant create table to %user;
grant create trigger to %user;
grant create view to %user;
grant global query rewrite to %user;

grant create any directory to %user;
grant drop any directory to %user;

begin
  execute immediate('grant select any dictionary to %user');
exception
  when others
  then
    null;
end;
/
commit;

grant execute on dbms_aqadm to %user;
grant execute on dbms_aq to %user; 
grant execute on sys.aq$_agent to %user;