SET FEED OFF
set HEADING off
SELECT '---------PRIVILEGIOS--------' FROM DUAL;
SET FEED ON
set HEADING on

select * from dba_role_privs
where GRANTED_ROLE = upper('&1');