SELECT * FROM dba_role_privs;

Or connect as user X and try:
SELECT * FROM session_privs;