select * from DBA_ROLE_PRIVS ,, If not enough

Have to join with DBA_ROLES and DBA_USERS