How to check the privileges assigned to a role

-- select all the role name and granted role

select *
from role_role_privs
order by 1;


-- select all the roles and their privilages

select *
from role_sys_privs
where ROLE = 'TABQ'
order by 1;

------------------------------------------------------

-- show all object privilages in a role

select *
from role_tab_privs
where role = 'TABQ';

https://forums.oracle.com/thread/2140697?start=0&tstart=0