SESSION_ROLES lists the roles that are currently enabled to the user.
SESSION_ROLES
ROLE
VARCHAR2(30)
NOT NULL