How to find which default roles a user has been assigned. Tnks.
select granted_role from dba_roles where grantee = 'YOUR_USER' where default_role='YES';
Jurij Modic 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.
Forum Rules