Saturday, July 25, 2020
Saturday, July 18, 2020
MoidIITDocID-581: How to exclude Oracle Maintained users in 11g?
To exclude oracle_maintained users in 11g:
select username from dba_users
where username NOT IN (select name from system.logstdby$skip_support)
order by 1;
To list oracle_maintained users in 11g:
select username from dba_users
where username IN (select name from system.logstdby$skip_support)
order by 1;
Hope this helps.
Moid Muhammad
Click here for the document.
Subscribe to:
Posts (Atom)