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

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

declare
	procedure exec(p_stmt in varchar2)
	is
	begin
		execute immediate p_stmt;
	exception
		when others then null;
	end;
begin

exec('revoke create database link from ~userSchema');                    
	exec('revoke create procedure from ~userSchema');                    
	exec('revoke drop any procedure from ~userSchema');
	exec('revoke execute any procedure from ~userSchema');                   
	exec('revoke create any sequence from ~userSchema');
	exec('revoke drop any sequence from ~userSchema');
	exec('revoke select any sequence from ~userSchema');

exec('revoke create session from ~userSchema');
	exec('revoke alter session from ~userSchema');

exec('revoke create any synonym from ~userSchema');
	exec('revoke drop any synonym from ~userSchema');

exec('revoke create table from ~userSchema');
	exec('revoke delete any table from ~userSchema');  
	exec('revoke drop any table from ~userSchema');  
	exec('revoke insert any table from ~userSchema');  
	exec('revoke select any table from ~userSchema');  
	exec('revoke update any table from ~userSchema');

exec('revoke create view from ~userSchema');
	exec('revoke drop any view from ~userSchema'); 
end;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de