show grants.sql
column obj format A35;
column grantor format A20;
column privilege format A15;
column grantee format A20;
set pagesize 80;
select grantee,owner||’.’||table_name obj,privilege from dba_tab_privs
where grantor = upper(‘&grantor’)
order by grantee,obj;
Discussion ¬