DBA_USERS

Oracle 11gR1

DBA_USERS describes all users of the database.

Related View

USER_USERS describes the current user. This view does not display the PASSWORD, PROFILE, PASSWORD_VERSIONS, or EDITIONS_ENABLED columns.

Column	Datatype	NULL	Description
USERNAME	VARCHAR2(30)	NOT NULL	Name of the user
USER_ID	NUMBER	NOT NULL	ID number of the user
PASSWORD	VARCHAR2(30)		Encrypted password
ACCOUNT_STATUS	VARCHAR2(32)	NOT NULL	Account status: · OPEN · EXPIRED · EXPIRED(GRACE) · LOCKED(TIMED) · LOCKED · EXPIRED & LOCKED(TIMED) · EXPIRED(GRACE) & LOCKED(TIMED) · EXPIRED & LOCKED · EXPIRED(GRACE) & LOCKED
LOCK_DATE	DATE		Date the account was locked if account status was LOCKED
EXPIRY_DATE	DATE		Date of expiration of the account
DEFAULT_TABLESPACE	VARCHAR2(30)	NOT NULL	Default tablespace for data
TEMPORARY_TABLESPACE	VARCHAR2(30)	NOT NULL	Name of the default tablespace for temporary tables or the name of a tablespace group
CREATED	DATE	NOT NULL	User creation date
PROFILE	VARCHAR2(30)	NOT NULL	User resource profile name
INITIAL_RSRC_CONSUMER_GROUP	VARCHAR2(30)		Initial resource consumer group for the user
EXTERNAL_NAME	VARCHAR2(4000)		User external name
PASSWORD_VERSIONS	VARCHAR2(8)		Database version in which the password was created or changed
EDITIONS_ENABLED	VARCHAR2(1)		Reserved for future use

Oracle data dictionary views