set echo off
set feedback off
set linesize 512

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

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

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