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 |