V$XS_SESSION_ROLES

The V$XS_SESSION_ROLES static data dictionary view displays all enabled application roles in application session in the current request.

Column Datatype NULL Description
ROLE_WSPACE VARCHAR2(129)   The workspace of the application role.
ROLE_NAME VARCHAR2(4000)   Name of enabled application role
FLAGS NUMBER   Status flag
CON_ID NUMBER   Container ID