spool priv_dba.rslt 

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

break on "ROLE";

/* ****************************************************** */
/*                                                        */
/*  - will show all the object privilege (not including   */
/*    column specific privleges) grante to the users      */
/*    within a given database                             */
/*                                                        */
/*         @c:\oracle\sql\priv_tab.sql                    */ 
/*                                                        */
/* ****************************************************** */

/* ***************************** */
/* Roles in the database         */
/* ***************************** */

select * from dba_roles;
order by 1;

/* ***************************** */
/* Granted Roles in the database */
/* ***************************** */

select * from role_role_privs
order by 1,2;

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









