USERNAME |
VARCHAR2(30) |
NOT NULL |
Name of the user |
USER_ID |
NUMBER |
NOT NULL |
ID number of the user |
PASSWORD |
VARCHAR2(30) |
|
This column is deprecated in favor of the AUTHENTICATION_TYPE column |
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 |
PASSWORD_VERSIONS |
VARCHAR2(8) |
|
Shows the list of versions of the password hashes (also known as "verifiers") existing for the account.
The PASSWORD_VERSIONS column value includes 10G if an old case-insensitive ORCL hash exists, 11G if a SHA-1 hash exists, and 12C if a new SHA-2 based SHA-512 hash exists.
Note that any combination of these verifiers can exist for any given account.
|
EDITIONS_ENABLED |
VARCHAR2(1) |
|
Indicates whether editions have been enabled for the corresponding user (Y) or not (N) |
AUTHENTICATION_TYPE |
VARCHAR2(8) |
|
Indicates the authentication mechanism for the user:
-
EXTERNAL - CREATE USER user1 IDENTIFIED EXTERNALLY;
-
GLOBAL - CREATE USER user2 IDENTIFIED GLOBALLY;
-
PASSWORD - CREATE USER user3 IDENTIFIED BY user3;
|
