DBA FUS‎ > ‎

Roles Granted With Admin

posted Sep 13, 2010, 6:22 AM by Sachchida Ojha
select grantee||': '||granted_role from dba_role_privs
where grantee not in('DBA','SYS','SYSTEM','WKSYS','LBACSYS','WMSYS')
and admin_option='YES'
and grantee not in (select distinct owner from dba_objects)
and grantee not in (select grantee from dba_role_privs where granted_role='DBA');
Comments