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. 

Followers