Select username from dba_users
where (default_tablespace= 'SYSTEM' or temporary_tablespace= 'SYSTEM')
and username not in
('AURORA$JIS$UTILITY$', 'AURORA$ORB$UNAUTHENTICATED', 'DBSNMP',
'MDSYS', 'ORDPLUGINS', 'ORDSYS', 'OSE$HTTP$ADMIN', 'OUTLN', 'REPADMIN',
'SYS', 'SYSTEM','TRACESVR','MTSSYS','DIP');
Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment