DBA FUS‎ > ‎

Access to System Tables/DBA Views

posted Sep 13, 2010, 6:10 AM by Sachchida Ojha
select grantee,privilege,owner,table_name from dba_tab_privs
    where (owner='SYS' or table_name like 'DBA_%')
      and privilege <> 'EXECUTE'
      and grantee not in ('PUBLIC','AQ_ADMINISTRATOR_ROLE','AQ_USER_ROLE',
               'AURORA$JIS$UTILITY$','OSE$HTTP$ADMIN','TRACESVR',
           'CTXSYS','DBA','DELETE_CATALOG_ROLE','EXECUTE_CATALOG_ROLE',
               'EXP_FULL_DATABASE','GATHER_SYSTEM_STATISTICS','HS_ADMIN_ROLE',
               'IMP_FULL_DATABASE','LOGSTDBY_ADMINISTRATOR','MDSYS','ODM',
               'OEM_MONITOR','OLAPSYS','ORDSYS','OUTLN','RECOVERY_CATALOG_OWNER',
               'SELECT_CATALOG_ROLE','SNMPAGENT','SYSTEM','WKSYS','WKUSER',
               'WMSYS','WM_ADMIN_ROLE','XDB','LBACSYS','PERFSTAT','XDBADMIN')
       and grantee not in (select grantee from dba_role_privs where granted_role='DBA')
    order by grantee;

Comments