A quick post as a reminder for myself some time down the road. After all, we all need reminders every once in a while!
Prior to Oracle Database 12c finding a list of default users within the database was always a pain. In Oracle Database 12c or later, this has become much simpler. Oracle introduced a column on the *_users views that allows the end users to identify what users are maintained by Oracle. This column name is ORACLE_MAINTAINED. The value of the column is either “N” or “Y”. If it is “Y”, then user account is maintained by Oracle.
A simple query of the ALL_USERS view will return about 57 different accounts that are maintained by Oracle in Oracle Database 19c (Autonomous Data Warehouse).
select * from all_users
where oracle_maintained = 'Y'
order by username;
For more information, the Oracle Database 19c docs can be referenced here.
Please follow and like:
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
