"Who has %ANY% system privilege? Directly granted or through a role"

akar direktben, akar role-on keresztul (Oracle 10g-ben tesztelve, rendszer felhasznalok kizarva):

SELECT drs.grantee USERNAME, 'ROLE: '||granted_role SOURCE
           FROM dba_role_privs drs
 

          WHERE drs.granted_role IN (SELECT DISTINCT grantee
                                                FROM dba_sys_privs
                                               WHERE PRIVILEGE LIKE '%ANY%')
            AND drs.grantee
                NOT IN
                   ('SYS',
                    'SYSTEM',
                    'DBSNMP',
                    'OUTLN',
                    'SCHEDULER_ADMIN',
                    'OEM_MONITOR',
                    'JAVADEBUGPRIV',
                    'IMP_FULL_DATABASE',
                    'EXP_FULL_DATABASE',
                    'EXFSYS',         
                    'AQ_ADMINISTRATOR_ROLE'
                   )
            AND EXISTS (
                   SELECT 1
                     FROM dba_users du
                    WHERE drs.grantee = du.username
                      AND du.account_status = 'OPEN')
UNION ALL
SELECT dsp.grantee USERNAME, 'PRIVILEGE: '||privilege SOURCE
           FROM dba_sys_privs dsp
          WHERE dsp.PRIVILEGE LIKE '%ANY%'
            AND dsp.grantee NOT IN
                   ('SYS',
                    'SYSTEM',
                    'DBSNMP',
                    'OUTLN',
                    'SCHEDULER_ADMIN',
                    'OEM_MONITOR',
                    'JAVADEBUGPRIV',
                    'IMP_FULL_DATABASE',
                    'EXP_FULL_DATABASE',
                    'EXFSYS',
                    'AQ_ADMINISTRATOR_ROLE'
                   )
            AND EXISTS (
                   SELECT 1
                     FROM dba_users du
                    WHERE dsp.grantee = du.username
                      AND du.account_status = 'OPEN')
       ORDER BY 1,2;