The system table SESSION_ROLES contains the roles that are active in the current database session.
SESSION_ROLES
ROLE |
CHAR(32) |
Name of the role |
See also:
Evaluating System Tables, SESSION_ROLES
SQL Reference Manual, Role Name (role_name)