Grants
SQL> SELECT 'grant '||privilege||' to '||grantee||';' FROM dba_sys_privs where GRANTEE in ('sername') union all SELECT 'grant '||granted_role||' to '||grantee||';' FROM dba_role_privs where grantee in ('sername') union all SELECT 'grant '|| privilege||' on '||owner||'.'||table_name||' to '||grantee||';' FROM dba_tab_privs where grantee in ('sername'); 2 3 4 5 select 'GRANT ' || PRIVILEGE || ' on ' || OWNER || '.' || TABLE_NAME || ' to ' || GRANTEE || ';' from dba_tab_privs where owner='sername' and grantable='NO' union all select 'GRANT ' || PRIVILEGE || ' on ' || OWNER || '.' || TABLE_NAME || ' to ' || GRANTEE || ' with GRANT OPTION;' from dba_tab_privs where owner='sername' and grantable='YES';