select distinct owner from dba_objects where owner not in ('SYS','SYSTEM','MDSYS','CTXSYS', 'ORDSYS','ORDPLUGINS','AURORA$JIS$UTILITY$', 'HR','ODM','ODM_MTR','OE','OLAPDBA','OLAPSYS', 'OSE$HTTP$ADMIN','OUTLN','LBACSYS','MTSYS', 'PM','PUBLIC','QS','QS_ADM','QS_CB','QS_CBADM', 'DBSNMP', 'QS_CS','QS_ES','QS_OS','QS_WS','RMAN','SH','WKSYS', 'WMSYS','XDB') and owner not in (select grantee from dba_role_privs where granted_role='DBA'); |
DBA FUS >