SESSION_ROLES

SESSION_ROLES describes the roles that are currently enabled to the user.

Column Datatype NULL Description
ROLE VARCHAR2(128) NOT NULL Name of the role