DBA_XS_ROLES

The DBA_XS_ROLES data dictionary view describes all existing application roles in the database.

Column Datatype NULL Description
NAME VARCHAR2(128)   Name of the application role
GUID RAW(16)   Globally unique identifier for the application role
EXTERNAL_SOURCE VARCHAR2(128)   External Source of the application role, such as LDAP
DEFAULT_ENABLED VARCHAR(3)   Whether or not the application role is enabled by default. Values can be YES or NO.
START_DATE TIMESTAMP(6) WITH TIME ZONE   Start date from which the application role is valid
END_DATE TIMESTAMP(6) WITH TIME ZONE   End date until which the application role is valid
DESCRIPTION VARCHAR2(4000)   Description of the application role