VIEW: SYS.KU$_SYSGRANT_VIEW

Source

View Text - Preformatted

select '1','1',
         p.privilege,
         u.name, p.name, g.sequence#, NVL(g.option$,0)
  from sys.sysauth$ g, sys.user$ u, sys.system_privilege_map p
  where g.grantee#=u.user# and
        g.privilege#=p.privilege and
        bitand(p.property, 1) != 1         /* Don't show non-SQL sys. grants */
        and
        (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (g.grantee#, 0) OR
                g.grantee#=1 OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, P.PRIVILEGE
, U.NAME
, P.NAME
, G.SEQUENCE#
, NVL(G.OPTION$
, 0)
FROM SYS.SYSAUTH$ G
, SYS.USER$ U
, SYS.SYSTEM_PRIVILEGE_MAP P
WHERE G.GRANTEE#=U.USER# AND G.PRIVILEGE#=P.PRIVILEGE AND BITAND(P.PROPERTY
, 1) != 1 /* DON'T SHOW NON-SQL SYS. GRANTS */ AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (G.GRANTEE#
, 0) OR G.GRANTEE#=1 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))