How to find which default roles a user has been assigned.
Tnks.
Printable View
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';
Sorry, the correct view is DBA_ROLE_PRIVS, not DBA_ROLES. Sorry for the confussion.