Static Data Dictionary Views, 387 of 625

DBA_USERS

DBA_USERS describes all users of the database. This view does not display the PROFILE column.

USER_USERS describes the current user. This view does not display the PASSWORD column.

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(30)`	`NOT NULL`	Indicates if the account is locked, expired, or unlocked
`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`	Default tablespace for temporary table
`CREATED`	`DATE`	`NOT NULL`	User creation date
`PROFILE`	`VARCHAR2(30)`	`NOT NULL`	User resource profile name
`INITIAL_RSRC_CONSUMER_GROUP`	`VARCHAR2(30)`		The initial resource consumer group for the user
`EXTERNAL_NAME`	`VARCHAR2(4000)`		User external name