Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Easy way to find non-default users?

Chuck1958May 15 2014 — edited Jun 5 2014

Is there an easy way to list all of the non-default oracle users apart from excluding them with a large NOT IN (...) clause?

For example in SQL Server you can find the non-system (default) databases by saying "select name from sys.databases where database_id > 4".
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2014
Added on May 15 2014
#general-database-discussions
12 comments
9,822 views