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.