select 'grant ' || granted_role || ' to ' || grantee || ';' from dba_role_privs where grantee = '&&grantee';
select 'grant ' || privilege || ' on ' || owner || '.' || table_name || ' to ' || grantee || ';' from dba_tab_privs where grantee = '&&grantee';
select 'grant ' || privilege || ' to ' || grantee || ';' from session_privs;
select 'grant ' || privilege || ' to ' || grantee || ';' from dba_sys_privs where grantee = '&&grantee';
select * from dba_col_privs where grantee = '&&grantee';
select * from dba_ts_quotas where username = '&&grantee';