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;