VIEW: SYS.EXPEXEMPT

Source

View Text - Preformatted

SELECT  COUNT(*)
        FROM    sys.sysauth$
        WHERE   (privilege# =
                        (SELECT privilege
                         FROM   sys.system_privilege_map
                         WHERE  name = 'EXEMPT ACCESS POLICY'))
        AND     grantee# = userenv('SCHEMAID')   /* user directly has priv */
        OR      (grantee# = userenv('SCHEMAID')   /* user has role with priv */
                        AND privilege# > 0
                        AND privilege# IN
                                (SELECT u1.privilege#
                                 FROM sys.sysauth$ u1, sys.sysauth$ u2
                                 WHERE u1.grantee# = userenv('SCHEMAID')
                                 AND u1.privilege# = u2.grantee#
                                 AND u2.privilege# =
                                      (SELECT privilege
                                       FROM   sys.system_privilege_map
                                       WHERE  name = 'EXEMPT ACCESS POLICY')))

View Text - HTML Formatted

SELECT COUNT(*)
FROM SYS.SYSAUTH$
WHERE (PRIVILEGE# = (SELECT PRIVILEGE
FROM SYS.SYSTEM_PRIVILEGE_MAP
WHERE NAME = 'EXEMPT ACCESS POLICY'))
AND GRANTEE# = USERENV('SCHEMAID') /* USER DIRECTLY HAS PRIV */ OR (GRANTEE# = USERENV('SCHEMAID') /* USER HAS ROLE WITH PRIV */
AND PRIVILEGE# > 0
AND PRIVILEGE# IN (SELECT U1.PRIVILEGE#
FROM SYS.SYSAUTH$ U1
, SYS.SYSAUTH$ U2
WHERE U1.GRANTEE# = USERENV('SCHEMAID')
AND U1.PRIVILEGE# = U2.GRANTEE#
AND U2.PRIVILEGE# = (SELECT PRIVILEGE
FROM SYS.SYSTEM_PRIVILEGE_MAP
WHERE NAME = 'EXEMPT ACCESS POLICY')))