DBA FUS‎ > ‎

Privileges Granted With Admin

posted Sep 13, 2010, 6:14 AM by Sachchida Ojha
select grantee,privilege from dba_sys_privs
where grantee not in
('SYS','SYSTEM','AQ_ADMINISTRATOR_ROLE','DBA','MDSYS','LBACSYS','SCHEDULER_ADMIN','WMSYS')
and admin_option='YES'
and grantee not in (select grantee from dba_role_privs where granted_role='DBA');
Comments