_____________________________________________________________________________________

set pages 1000
set lines 200
_____________________________________________________________________________________

DBA ROLES INFO
==============
describe DBA_ROLES

select ROLE
from DBA_ROLES
where ROLE like 'DB%'
order by 1;

--------------------
describe DBA_ROLE_PRIVS

select *
from DBA_ROLE_PRIVS
where GRANTED_ROLE like 'DB%'
order by 1, 2;

--------------------
describe DBA_ROLE_PRIVS

select GRANTEE, 'xnamex', GRANTED_ROLE
from DBA_ROLE_PRIVS
where GRANTED_ROLE like 'DB%'
order by 1, 2;

--------------------
describe DBA_USERS

select distinct PROFILE
from DBA_USERS
order by 1;

select USERNAME
from DBA_USERS
where PROFILE = 'DEFAULT'
order by 1;

_____________________________________________________________________________________

_____________________________________________________________________________________