How to find which default roles a user has been assigned.
select granted_role from dba_roles where grantee = 'YOUR_USER' where default_role='YES';
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Sorry, the correct view is DBA_ROLE_PRIVS, not DBA_ROLES. Sorry for the confussion.