DBA_USERS
describes all users of the database.
USER_USERS
describes the current user. This view does not display the PASSWORD
or PROFILE
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:
|
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 |
See Also:
"USER_USERS"