ORACLE_MAINTAINED column in Oracle 12c dictionary

Lets say someone asked you what are the Oracle database built-in accounts (Oracle internal) in your current database ?

Most oracle database dictionary views have a column called ORACLE_MAINTAINED that was introduced in Oracle 12c release.


SQL> select username,last_login,oracle_maintained from dba_users where oracle_maintained=’Y’;


Finding Oracle built-in roles:


SQL> select role,oracle_maintained from dba_roles where oracle_maintained=’Y’;


































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