check which user has which role

You can use the below tables to find which user has assigned which role.

DBA_TAB_PRIVS ROLE_TAB_PRIVS DBA_ROLE_PRIVS

Run the below script:

SELECT *                                 FROM dba_role_privs                               ORDER BY grantee;