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.

Tansdot
My mistake, it's dba_sys_privs and not dba_role_privs...