set echo off
set feedback off
set linesize 512

prompt --------------------------------------------------
prompt - Liste des roles attribues aux roles de la base -
prompt --------------------------------------------------

break on GRANTED_ROLE skip 1
column ADMIN format a8
column DEFAUT format a8

SELECT 
   GRANTED_ROLE, 
   GRANTEE, 
   ADMIN_OPTION ADMIN, 
   DEFAULT_ROLE DEFAUT
FROM 
   SYS.DBA_ROLE_PRIVS
WHERE GRANTEE IN (SELECT ROLE FROM DBA_ROLES)
ORDER BY 
   GRANTED_ROLE, 
   ADMIN_OPTION;
