Search notes:

Oracle: Default roles of a user

Querying a user's default roles

select
   rpr.default_role,
   rpr.granted_role   
from
   sys.dba_role_privs rpr
where
   rpr.grantee = 'RENE'
order by
   rpr.default_role,
   rpr.granted_role;

Index