Originally posted by harrygulls
Thanks. But this is not really helping. I couldn't find anything which provides USERS and their ROLES.
SELECT GRANTED_ROLE, GRANTEE FROM DBA_ROLE_PRIVS