[Home] [Help] [Dependency Information]
Object Name: | DBA_XS_USERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All the Real Application Security users defined in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (128) | Name of the user | |
GUID | RAW | (16) | GUID of the user | |
EXTERNAL_SOURCE | VARCHAR2 | (128) | External source of the user | |
ROLES_DEFAULT_ENABLED | VARCHAR2 | (3) | Indicates whether all the roles granted to the user are default enabled (YES) or not (NO) | |
STATUS | VARCHAR2 | (8) | Status of the user. Possible values are ACTIVE, INACTIVE | |
ACCOUNT_STATUS | VARCHAR2 | (32) | Yes | Direct Login status of the user caused due to profile associated with the user |
LOCK_DATE | DATE | Direct login account locking date | ||
EXPIRY_DATE | DATE | Direct login account expiry date | ||
PROFILE | VARCHAR2 | (128) | Name of database profile associated with the user | |
SCHEMA | VARCHAR2 | (128) | User schema | |
START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | Effective start date for the user | |
END_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | 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(e.g. SALTED SHA1, SHA512) assigned to the direct logon user | |
DESCRIPTION | VARCHAR2 | (4000) | Description of the user |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, GUID
, EXTERNAL_SOURCE
, ROLES_DEFAULT_ENABLED
, STATUS
, ACCOUNT_STATUS
, LOCK_DATE
, EXPIRY_DATE
, PROFILE
, SCHEMA
, START_DATE
, END_DATE
, DIRECT_LOGON_USER
, VERIFIER_TYPE
, DESCRIPTION
FROM SYS.DBA_XS_USERS;
|
|
|