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; |
DBA FUS >