spool priv_rol.rslt 

set linesize 80;
set pagesize 1000;
set long 50;
set echo on;

break on "GRANTEE";

/* ****************************************************** */
/*                                                        */
/*  - will show all the roles granted to usera and other  */
/*    roles within a given database                       */
/*                                                        */
/*         @c:\oracle\sql\priv_rol.sql                    */ 
/*                                                        */
/* ****************************************************** */

select grantee	"GRANTEE", 
       granted_role,
       admin_option 
from dba_role_privs 
order by 1, 2;

set echo off;
spool off;
set long 80;
commit;









