DBA_USERS

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)`		Indicates whether the user is authenticated by OID (`GLOBAL`) or externally authenticated (`EXTERNAL`); NULL otherwise
`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