Originally posted by tansdot DBA_ROLE_PRIVS shows which users have been granted what roles ; it doesnt show the privileges of the roles. To see that query the ROLE_SYS_PRIVS & you can figure the difference.
My mistake, it's dba_sys_privs and not dba_role_privs...
One little sneaky thing to be aware of when granting RESOURCE that does not happen when you grant CONNECT -
When you grant RESOURCE to a user, Oracle automatically
also grants UNLIMITED TABLESPACE to that user. So if you don't want to be granting UNLIMITED TABLESPACE, be sure to revoke it after you grand RESOURCE. (The same thing happens when you grant DBA to a user).