USER_XS_USERS
The USER_XS_USERS data dictionary view describes the current application users own account information.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
NAME |
VARCHAR2(128) |
Name of the current application user | |
STATUS |
VARCHAR2(8) |
Status of the current application user. Valid values are ACTIVE and INACTIVE only. |
|
ACCOUNT_STATUS |
VARCHAR2(32) |
NOT NULL |
Direct login password policy account status of the current user. Valid values are UNLOCK, LOCKED, and EXPIRED. UNLOCK means the current user’s account is open. |
LOCK_DATE |
DATE |
The date the account became locked for the direct login session for the current user | |
EXPIRY_DATE |
DATE |
The date the passward became expired or the direct login session for the current user | |
DIRECT_LOGON_USER |
VARCHAR2(3) |
Indicates whether this user has direct logon capability | |
DESCRIPTION |
VARCHAR2(4000) |
Description of the application user | |
MANDATORY_PROFILE_VIOLATION |
varchar2(3) |
Denotes whether the user’s account password violates the mandatory profile’s password complexity requirements. |