DBA FUS‎ > ‎

Unauthorized Object Owner

posted Sep 13, 2010, 6:04 AM by Sachchida Ojha
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');

Comments