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;