spool priv_ses.rslt 

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

break on "GRANTEE";

/* ****************************************************** */
/*                                                        */
/*  - will show all the roles for the issuer as well as   */
/*    the grants to the user within a given database      */
/*                                                        */
/*         @C:\rkupcuna05_ora\Oracle\SQL\priv_ses.sql     */ 
/*                                                        */
/* ****************************************************** */

/* ********************************** */
/* show the roles for the issuer      */
/* ********************************** */

select * from session_roles;

/* ********************************** */
/* show the privileges for the issuer */
/* ********************************** */

select * from session_privs;

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









