Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\grantpriv.sql

grant select on sys.v_$system_parameter to %user; 
grant select on sys.v_$session to %user with grant option;

--fix bug 5060857
grant select on sys.v_$instance to %user with grant option;
grant select on sys.gv_$session to %user with grant option; 
grant select on sys.v_$mystat to %user with grant option;
--sochen:removed due to it is very powerful....
--grant alter user to %user;    
--used to check whether normal user have default role set to ALL
grant select on sys.dba_role_privs to %user;
grant select on sys.dba_tablespaces to %user;
-- with grant option;
grant execute on sys.dbms_lock to %user; 
-- grant execute on sys.XMLDOM to %user; 
grant select on sys.dbms_lock_allocated to %user;
grant select on sys.v_$lock to %user;
--grant select any dictionary to %user; 
grant execute on sys.dbms_snapshot to %user; 
grant execute on sys.dbms_obfuscation_toolkit to %user with grant option;

--sochen: the following 2 are just here for demo purpose, should be
--  removed later and added from repos-assistant instead
--now whenever want to create dbuser from owbclient,need to provide
--sysdba info for security consideration
--grant create user to %user;
--grant alter user to %user;
 
grant CREATE DATABASE LINK to %user;

--fix bug 5057967
--grant CREATE PUBLIC DATABASE LINK to %user;

grant CREATE DIMENSION to %user;
grant CREATE INDEXTYPE to %user;
grant CREATE SEQUENCE to %user;
grant CREATE SESSION to %user with admin option;
grant ALTER SESSION to %user;
grant create snapshot to %user; 
grant CREATE SYNONYM  to %user;
grant CREATE PROCEDURE to %user;

--fix bug: 5057967
--grant CREATE ANY PROCEDURE to %user;
--grant DROP ANY PROCEDURE to %user;

--fix bug: 5057967
--grant CREATE PUBLIC SYNONYM to %user;
--grant DROP PUBLIC SYNONYM to %user;
grant CREATE TABLE to %user;
grant CREATE TYPE to %user;
grant CREATE VIEW to %user;
grant CREATE MATERIALIZED VIEW to %user;
grant CREATE TRIGGER to %user;
grant global query rewrite to %user;
grant unlimited tablespace to %user;
 
--by sochen
grant CREATE ROLE to %user;

--confirmed by jaime, this cwmaccess actually not be used anymore
--create role cwmaccess;

--grant CREATE MATERIALIZED VIEW to %user;

--fix bug 5061162
grant execute on sys.dbms_lob to %user;
grant execute on sys.dbms_job to %user;

--by sochen for create application context 
grant create any context to %user;
grant drop any context to %user;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de