Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\platform_system_rights.sql
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;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de