grant connect to %user with admin option;

grant aq_administrator_role to %user;
grant aq_user_role to %user;
grant alter session to %user with admin option;
grant unlimited tablespace to %user with admin option;
grant create database link to %user with admin option;
grant create type to %user with admin option;
grant create dimension to %user with admin option;
grant create indextype to %user with admin option;
grant create procedure to %user with admin option;

--fix bug 5057967
--grant create public synonym to %user with admin option;
--grant drop public synonym to %user with admin option;
grant create sequence to %user with admin option;
grant create session to %user with admin option;
grant create snapshot to %user with admin option;
grant create synonym to %user with admin option;
grant create table to %user with admin option;
grant create trigger to %user with admin option;
grant create view to %user with admin option;
grant global query rewrite to %user with admin option;
grant select any table to %user;
grant select any sequence to %user;
--Bug 7507745: ANALYZE PRIVILEGES LIKE *ANY* TO OWBSYS WITH ADMIN OPTION 
--grant create any directory to %user with admin option;
--grant drop any directory to %user with admin option;

begin
  execute immediate('grant create job to %user with admin option');
exception
  when others
  then
    null;
end;
/
commit;

grant select_catalog_role to %user;

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

commit;
begin
  execute immediate('grant create external job to %user');
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate('grant OLAP_USER to %user with admin option');
  execute immediate('grant select on olapsys.xml_load_log to %user ');
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate('grant CWM_USER to %user with admin option');
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate('grant execute on sys.interactionExecute to %user with grant option');
  execute immediate('grant all on olapsys.xml_loadid_sequence to %user with grant option');
  execute immediate('grant all on olapsys.xml_load_log to %user with grant option');
exception
  when others
  then
    null;
end;
/
commit;



grant execute on sys.dbms_aqadm to %user with grant option;
grant execute on sys.dbms_aq to %user with grant option; 
grant execute on sys.aq$_agent to %user with grant option;
grant execute on sys.dbms_lock to %user;
grant execute on sys.dbms_streams_adm to %user;
grant execute on sys.dbms_capture_adm to %user;


grant javaidpriv to %user;
grant javauserpriv to %user;
grant java_admin to %user;

begin
  dbms_java.grant_permission(upper('%user'), 'java.util.PropertyPermission', '*', 'read,write');
end;
/

begin
  dbms_java.grant_permission(upper('%user'),'java.io.FilePermission', '<<ALL FILES>>', 'read,write,execute,delete'); 
end;
/

begin
  dbms_java.grant_permission(upper('%user'),'java.lang.RuntimePermission','*','writeFileDescriptor');
end;
/

grant select on sys.dba_role_privs to %user with grant option;
grant select on sys.v_$session to %user with grant option;
grant select on sys.gv_$session to %user with grant option;
grant select on sys.v_$active_instances to %user with grant option;
grant select on owbsys.owbrtps to %user with grant option;
grant all on owbsys.raw_owbrepos to %user with grant option;