VIEW: SYS.KU$_ROGRANT_VIEW

Source

View Text - Preformatted

select '1','0',
          u1.user#, u1.name, u2.name, u2.user#, NVL(g.option$, 0), g.sequence#
  from    sys.user$ u1, sys.user$ u2, sys.sysauth$ g
  where   u1.user# = g.grantee# AND
          u2.user# = g.privilege# AND
          g.privilege# > 0
          AND (SYS_CONTEXT('USERENV','CURRENT_USERID') =0
                OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, U1.USER#
, U1.NAME
, U2.NAME
, U2.USER#
, NVL(G.OPTION$
, 0)
, G.SEQUENCE#
FROM SYS.USER$ U1
, SYS.USER$ U2
, SYS.SYSAUTH$ G
WHERE U1.USER# = G.GRANTEE# AND U2.USER# = G.PRIVILEGE# AND G.PRIVILEGE# > 0
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') =0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))