DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_XS_USERS

Object Details
Object Name: DBA_XS_USERS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All the Real Application Security users defined in the database

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

SYS.DBA_XS_USERS references the following:

SchemaSYS
TablePROFILE$
TablePROFNAME$
TableUSER_ASTATUS_MAP
TableXS$OBJ
TableXS$PRIN
TableXS$VERIFIERS
SYS.DBA_XS_USERS is referenced by following:

SchemaPUBLIC
SynonymDBA_XS_USERS
SchemaSYS
ViewUSER_XS_USERS