Oracle role: DBA

select
   spr.name,
   case when dsp.privilege is null then 'not granted' else 'granted' end granted_to_dba
from
   system_privilege_map spr left join
   dba_sys_privs        dsp on spr.name    =  dsp.privilege and
                               dsp.grantee = 'DBA'
order by
   dsp.privilege nulls last,
   spr.name;