SESSION_ROLES

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

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