DBA_XS_DYNAMIC_ROLES

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

Column Datatype NULL Description
NAME VARCHAR2(128)   Name of the dynamic application role
GUID RAW(16)   Globally unique identifier for the dynamic application role
DURATION NUMBER   Duration (in minutes) for which the role has been active
SYSTEM_DEFINED VARCHAR2(3)   Indicates whether the application role is a system-defined role. Possible values are YES and NO.
SCOPE VARCHAR2(7)   Scope of the application role. Possible values are SESSION and REQUEST.
ACL VARCHAR2(128)   The Real Application Security session privilege.
DESCRIPTION VARCHAR2(4000)   Description of the dynamic application role.