DBA FUS‎ > ‎

Active Schema Owner Account

posted Sep 13, 2010, 6:07 AM by Sachchida Ojha
select distinct owner from dba_objects, dba_users
         where owner not in
         ('SYS','SYSTEM','MDSYS','CTXSYS',
         'ORDSYS','ORDPLUGINS','AURORA$JIS$UTILITY$',
         'ODM','ODM_MTR','OLAPDBA','OLAPSYS','MTSSYS',
     'OSE$HTTP$ADMIN','OUTLN','LBACSYS',
         'PUBLIC','DBSNMP','RMAN','WKSYS',
     'WMSYS','XDB') 
        and owner = username
        and account_status not like '%LOCKED';

Comments