EXA_USER_ROLE_PRIVS

This system table lists all of the roles directly granted to the current user (not through other roles). All users have access to the table.

Column Name Description
GRANTEE Name of the user
GRANTED_ROLE Name of the role possessed by the user
ADMIN_OPTION Information on whether the role can be passed on to other users and roles