spool all_role.rslt 

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

break on "ROLE" on "PRIVILEGE";

/* ****************************************************** */
/*                                                        */
/*  - will show all the roles within a given database     */
/*                                                        */
/*         @c:\oracle\sql\all_role.sql                    */ 
/*                                                        */
/* ****************************************************** */

select 	role		"ROLE",
	privilege	"PRIVILEGE",
	ADMin_option
from 	role_sys_privs 
order by 1 asc, 2 asc;

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









