Query dba_role_privs
Is there any better way to run this SELECT sql:
select grantee, default role, granted_role from dba_role_privs where default_role='YES' and grantee not in (select role from dba_roles);
it took me long time to complete.
select grantee, default role, granted_role from dba_role_privs where default_role='YES' and grantee not in (select role from dba_roles);
it took me long time to complete.
0