Oracle Database 12c Administrative System Accounts

in Oracle Database 12c, the following are the list of system administration accounts:



and the following is the list of Operating System Accounts (OS Accounts) and its corresponding Oracle 12c System Admin Accounts:




to view all accounts in your database and their status, use the following query:

FROM dba_users
ORDER BY username;


you can also use this query, from root container in 12c:

FROM cdb_users u
,v$containers c
WHERE u.con_id = c.con_id
ORDER BY, u.username;




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s