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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s