SESSION_ROLES

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

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