Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\misc\create_wmp

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\misc\create_wmp_user.sql

declare
begin

execute immediate 'grant create database link to ~userSchema';                    
	execute immediate 'grant create procedure to ~userSchema';                    
	execute immediate 'grant drop any procedure to ~userSchema';
	execute immediate 'grant execute any procedure to ~userSchema';                   
	execute immediate 'grant create any sequence to ~userSchema';
	execute immediate 'grant drop any sequence to ~userSchema';
	execute immediate 'grant select any sequence to ~userSchema';

execute immediate 'grant create session to ~userSchema';
	execute immediate 'grant alter session to ~userSchema';

execute immediate 'grant create any synonym to ~userSchema';
	execute immediate 'grant drop any synonym to ~userSchema';

execute immediate 'grant create table to ~userSchema';
	execute immediate 'grant delete any table to ~userSchema';  
	execute immediate 'grant drop any table to ~userSchema';  
	execute immediate 'grant insert any table to ~userSchema';  
	execute immediate 'grant select any table to ~userSchema';  
	execute immediate 'grant update any table to ~userSchema';

execute immediate 'grant create view to ~userSchema';
	execute immediate 'grant drop any view to ~userSchema';

end;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de