DBA_XS_USERS
The DBA_XS_USERS data dictionary view describes all existing application users defined in the database.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
NAME |
VARCHAR2(128) |
Name of the application user | |
GUID |
RAW(16) |
Globally unique identifier for the application user | |
EXTERNAL_SOURCE |
VARCHAR2(128) |
External Source of application users, such as LDAP | |
ROLES_DEFAULT_ENABLED |
VARCHAR2(3) |
Indicates whether all the application roles granted to the application user are enabled by default. Valid values are YES and NO. |
|
STATUS |
VARCHAR2(8) |
Status of the application user. Valid values are ACTIVE and INACTIVE. |
|
ACCOUNT_STATUS |
VARCHAR2(32) |
NOT NULL |
Direct login password policy account status of the user. Indicates whether the account is locked, expired, or unlocked. |
LOCK_DATE |
DATE |
The date the account became locked for the direct login user | |
EXPIRY_DATE |
DATE |
The date the passward became expired for the direct login user | |
PROFILE |
VARCHAR2(128) |
The name of the database profile associated with the application user | |
SCHEMA |
VARCHAR2(128) |
Application user schema | |
START_DATE |
TIMESTAMP(6) WITH TIME ZONE |
Effective start date for the user | |
END_DATE |
TIMESTAMP(6) WITH TIME ZONE |
Effective end date for the user | |
DIRECT_LOGON_USER |
VARCHAR2(3) |
Indicates whether this user has direct logon capability | |
VERIFIER_TYPE |
VARCHAR2(11) |
Type of the verifier assigned to the direct logon user. Only XS_SHA512 and XS_SALTED_SHA1 are allowed.) |
|
ACL |
VARCHAR2(128) |
The Real Application Security session privilege. | |
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. |