VIEW: SYS.KU$_ON_USER_GRANT_VIEW

Source

View Text - Preformatted

select '1','1',
         u.name, u1.name, u2.name, us.sequence#
  from sys.userauth$ us, sys.user$ u, sys.user$ u1, sys.user$ u2
  where us.user#=u.user# and us.grantor#= u1.user# and us.grantee#=u2.user# and
        (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (us.grantee#, 0) OR
                us.grantee#=1 OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, U.NAME
, U1.NAME
, U2.NAME
, US.SEQUENCE#
FROM SYS.USERAUTH$ US
, SYS.USER$ U
, SYS.USER$ U1
, SYS.USER$ U2
WHERE US.USER#=U.USER#
AND US.GRANTOR#= U1.USER#
AND US.GRANTEE#=U2.USER# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (US.GRANTEE#
, 0) OR US.GRANTEE#=1 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))