Skip to Main Content

Oracle Database Free

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!

Please amend the values for 'ORACLE_MAINTAINED' in DBA_USERS

NorbertKlApr 28 2023

Hello all,

since years I have hard time to separate the ‘system’ users in the oracle db from the ‘business’ users. Even in 23c in the pdb

select username from dba_users where oracle_maintained <> 'Y' order by 1;

shows

ORDS_METADATA
ORDS_PUBLIC_USER
PDBADMIN

I consider the users as oracle-maintained, aren't they ?

If I am right i would very much appreciate if you could clean this up.

Background:

In my last project I had to administer some 40 Oracle databases , some of them very old, all of them different in subtle ways and it would have been very useful to be able to select only the relevant users from the business point of view. In the end I had to build my own metadata table to do this.

This post has been answered by Loïc Lefèvre-Oracle on May 2 2023
Jump to Answer
Comments
Post Details
Added on Apr 28 2023
8 comments
1,887 views