DBA FUS‎ > ‎

Priv granted with Grant Option

posted Sep 13, 2010, 6:15 AM by Sachchida Ojha
select grantee||': '||owner||'.'||table_name from dba_tab_privs
      where grantable='YES'
      and owner not in ('SYS','MDSYS','ORDPLUGINS',
                        'ORDSYS','SYSTEM','WMSYS','XDB','LBACSYS')
      and grantee not in (select grantee from dba_role_privs where granted_role='DBA')
      order by grantee;
Comments