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