Question: What is the purpose of
the new 12c column oracle_maintained in the
dba_users and dba_roles views in Oracle 12c?
Answer: When you install Oracle,
he installed lots of user ID's (schemas) and many of these
schemas are for internal user only. In Oracle 12c,
these "internal user ID include these values. In
Oracle 12c these "internal" user ID's have a dba_users
account_status value of "LOCKED & EXPIRED':
ANONYMOUS
APEX_040200
APEX_PUBLIC_USER
APPQOSSYS
AUDSYS
CTXSYS
DBSNMP
DIP
DVF
DVSYS
FLOWS_FILES
GSMADMIN_INTERNAL
GSMCATUSER
GSMUSER
LBACSYS
MDDATA
MDSYS
OJVMSYS
OLAPSYS
ORACLE_OCM
ORDDATA
ORDPLUGINS
ORDSYS
OUTLN
SI_INFORMTN_SCHEMA
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR
SYSBACKUP
SYSDG
SYSKM
WMSYS
XDB
XS$NULL
The oracle_maintained column in dba_users
indicates if an Oracle user ID is actively being used.
The oracle_maintained column is a Boolean-ish column with
values of "Y" and "N", indicating whether Oracle is
maintaining the user ID.
select
username,
oracle_maintained,
account_status
from
dba_users
where
account_status = 'OPEN'
order by
oracle_maintained,
username;
USERNAME
ORACLE_MAINTAINED ACCOUNT_STATUS
------------------ -
--------------
MYSCHEMA
Y
OPEN
SYS
Y
OPEN
SYSTEM
Y
OPEN
