eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.CDB_USERS

Object Details

Object Name:	CDB_USERS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information about all users of the database in all containers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
USERNAME	VARCHAR2	(30)	Yes	Name of the user
USER_ID	NUMBER		Yes	ID number of the user
PASSWORD	VARCHAR2	(30)		Deprecated from 11.2 -- use AUTHENTICATION_TYPE instead
ACCOUNT_STATUS	VARCHAR2	(32)	Yes
LOCK_DATE	DATE
EXPIRY_DATE	DATE
DEFAULT_TABLESPACE	VARCHAR2	(30)	Yes	Default tablespace for data
TEMPORARY_TABLESPACE	VARCHAR2	(30)	Yes	Default tablespace for temporary tables
CREATED	DATE		Yes	User creation date
PROFILE	VARCHAR2	(128)	Yes	User resource profile name
INITIAL_RSRC_CONSUMER_GROUP	VARCHAR2	(128)		User's initial consumer group
EXTERNAL_NAME	VARCHAR2	(4000)		User external name
PASSWORD_VERSIONS	VARCHAR2	(12)		List of versions of password hashes (e.g. 11G for SHA-1, 12C for SHA-512)
EDITIONS_ENABLED	VARCHAR2	(1)		Whether editions are enabled for this user
AUTHENTICATION_TYPE	VARCHAR2	(8)		Authentication mechanism for the user
PROXY_ONLY_CONNECT	VARCHAR2	(1)		Whether this user can connect only through a proxy
COMMON	VARCHAR2	(3)		Indicates whether this user is Common
LAST_LOGIN	TIMESTAMP(9) WITH TIME ZONE	(20)
ORACLE_MAINTAINED	VARCHAR2	(1)		Denotes whether the user was created, and is maintained, by Oracle-supplied scripts. A user for which this has the value Y must not be changed in any way except by running an Oracle-supplied script.
CON_ID	NUMBER			container id

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USERNAME
,      USER_ID
,      PASSWORD
,      ACCOUNT_STATUS
,      LOCK_DATE
,      EXPIRY_DATE
,      DEFAULT_TABLESPACE
,      TEMPORARY_TABLESPACE
,      CREATED
,      PROFILE
,      INITIAL_RSRC_CONSUMER_GROUP
,      EXTERNAL_NAME
,      PASSWORD_VERSIONS
,      EDITIONS_ENABLED
,      AUTHENTICATION_TYPE
,      PROXY_ONLY_CONNECT
,      COMMON
,      LAST_LOGIN
,      ORACLE_MAINTAINED
,      CON_ID
FROM SYS.CDB_USERS;

Dependencies

[top of page]

SYS.CDB_USERS does not reference any database object

SYS.CDB_USERS is referenced by following:

PUBLIC: CDB_USERS
SYS: PRVT_ADVISOR - show dependent code