USERNAME |
VARCHAR2(128) |
The name of the user.
Always NOT NULL. |
USER_ID |
NUMBER |
The ID number of the user.
Always NOT NULL. |
ACCOUNT_STATUS |
VARCHAR2(32) |
The account status. The possible values are: OPEN - The account is open.EXPIRED - The password for the account has expired, either because the PASSWORD_LIFE_TIME limit was reached or because the password was expired by the ALTER USER ... PASSWORD EXPIRE command. The user can log in with the expired password, then change the password.EXPIRED(GRACE) - The password for the account has expired because the PASSWORD_LIFE_TIME limit was reached, but the password change grace period (PASSWORD_GRACE_TIME) has not yet elapsed. The user can log in with the expired password, but will receive an ORA-28002 warning as a reminder that the password must soon be changed. If the PASSWORD_GRACE_TIME elapses, the user can log in with the expired password, then change the password.LOCKED - The account is locked, either by the ALTER USER ... ACCOUNT LOCK command, or because the number of consecutive failed login attempts exceeded the FAILED_LOGIN_ATTEMPTS limit and the value of PASSWORD_LOCK_TIME is UNLIMITED. The account can be unlocked by the ALTER USER ... ACCOUNT UNLOCK command.LOCKED(TIMED) - The account is locked because the number of consecutive failed login attempts exceeded the FAILED_LOGIN_ATTEMPTS limit and the PASSWORD_LOCK_TIME has not yet elapsed. The account can be unlocked either by the ALTER USER... ACCOUNT UNLOCK command or by waiting until the PASSWORD_LOCK_TIME has elapsed.EXPIRED & LOCKED - The password for the account has expired, as described for the EXPIRED account status, and the account is locked as described for the LOCKED account status. The account can first be unlocked as described for the LOCKED account status, then the password can be changed as described for the EXPIRED account status.EXPIRED(GRACE) & LOCKED - The password for the account has expired, as described for the EXPIRED(GRACE) account status, and the account is locked as described for the LOCKED account status. The account can first be unlocked as described for the LOCKED account status, then the password can be changed as described for the EXPIRED(GRACE) account status.EXPIRED & LOCKED(TIMED) - The password for the account has expired, as described for the EXPIRED account status, and the account is locked as described for the LOCKED(TIMED) account status. The account can first be unlocked as described for the LOCKED(TIMED) account status, then the password can be changed as described for the EXPIRED account status.EXPIRED(GRACE) & LOCKED(TIMED) - The password for the account has expired, as described for the EXPIRED(GRACE) account status, and the account is locked as described for the LOCKED(TIMED) account status. The account can first be unlocked as described for the LOCKED(TIMED) account status, then the password can be changed as described for the EXPIRED(GRACE) account status.OPEN & IN ROLLOVER - The account is in the password rollover period. The user can log in with either the earlier password or the new password. However, at the time the user logs in, the server recalculates whether the account is still in its password rollover period. If the password rollover period has elapsed, then the login will succeed only if the new password was specified, and the account status will change to OPEN.EXPIRED & IN ROLLOVER - The account is in the password rollover period and the password is expired as described for the EXPIRED account status. The user can log in with either the earlier password or the new password. However, at the time the user logs in, the server recalculates whether the account is still in its password rollover period. If the password rollover period has elapsed, then the login will succeed only if the new password was specified, and the account status will change to EXPIRED. After logging in, the user will be prompted to change the password.LOCKED & IN ROLLOVER - The account is in the password rollover period and is also locked as described for the LOCKED account status. The account can be unlocked as described for the LOCKED account status, after which the user can log in as described for the OPEN & IN ROLLOVER account status.EXPIRED & LOCKED & IN ROLLOVER - The account is in the password rollover period, its password is expired as described for the EXPIRED account status, and the account is locked as described for the LOCKED account status. The account can be unlocked as described for the LOCKED account status, after which the user can log in as described for the EXPIRED & IN ROLLOVER account status.LOCKED(TIMED) & IN ROLLOVER - The account is in the password rollover period and is also locked as described for the LOCKED(TIMED) account status. The account can be unlocked as described for the LOCKED(TIMED) account status, after which the user can log in with either the earlier password or the new password. However, at the time the user logs in, the server recalculates whether the account is still in its password rollover period. If the password rollover period has elapsed, then the login will succeed only if the new password was specified.EXPIRED & LOCKED(TIMED) & IN ROLLOVER - The account is in the password rollover period, its password is expired as described for the EXPIRED account status, and the account is locked as described for the LOCKED(TIMED) account status. The account can be unlocked as described for the LOCKED(TIMED) account status, after which the user can log in as described for the EXPIRED & IN ROLLOVER account status.
Always NOT NULL. |
LOCK_DATE |
DATE |
The date when the account was locked. Applies only if the account status was LOCKED. |
EXPIRY_DATE |
DATE |
The expiration date of the account. |
DEFAULT_TABLESPACE |
VARCHAR2(30) |
The default tablespace for data.
Always NOT NULL. |
TEMPORARY_TABLESPACE |
VARCHAR2(30) |
The name of the default tablespace for temporary tables or the name of a tablespace group.
Always NOT NULL. |
LOCAL_TEMP_TABLESPACE |
VARCHAR2(30) |
The default local temporary tablespace for the user. |
CREATED |
DATE |
The date when the user was created.
Always NOT NULL. |
INITIAL_RSRC_CONSUMER_GROUP |
VARCHAR2(128) |
The initial resource consumer group for the user. |
EXTERNAL_NAME |
VARCHAR2(4000) |
The external name of the user. |
PROXY_ONLY_CONNECT |
VARCHAR2(1) |
Specifies whether the user can connect directly (N) or whether the account can only be proxied (Y) by users who have proxy privileges for this account. |
COMMON |
VARCHAR2(3) |
Specifies whether the user is common.
The possible values are: YES - The user is common.NO - The user is local.
|
ORACLE_MAINTAINED |
VARCHAR2(1) |
Specifies whether the user account is maintained by Oracle.
The possible values are: YES - An Oracle-maintained user.NO - A regular user managed by a DBA.
|
INHERITED |
VARCHAR2(3) |
Specifies whether the user definition was inherited from another container (YES) or not (NO). |
DEFAULT_COLLATION |
VARCHAR2(100) |
The default collation for the user’s schema. |
IMPLICIT |
VARCHAR2(3) |
Specifies whether the user is a common user created by an implicit application (YES) or not (NO). |
ALL_SHARD |
VARCHAR2(3) |
Specifies whether the user was created with shard DDL enabled in a sharded database.
The possible values are: YES - The user was created with shard DDL enabled and therefore exists on all shards and in the shard catalog.NO - The user was created without shard DDL enabled and exists only in the database where it was created.
In a non-sharded database, the value of the column is always NO. |
PASSWORD_CHANGE_DATE |
DATE |
The external name of the user.
This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, the column value is NULL.
Note: The column is available starting with Oracle Database 19c. |