VIEW: SYS.KU$_M_VIEW_LOG_FH_VIEW

Source

View Text - Preformatted

select '1','0',
         fhtv.obj_num,
         value(mvlv),
         value(fhtv)
  from   obj$ o, user$ u, sys.ku$_fhtable_view fhtv, ku$_m_view_log_view mvlv
  where  mvlv.mowner = u.name
     and mvlv.log    = o.name
     and o.owner#    = u.user#
     and o.type#     = 2
     and o.obj#      = fhtv.schema_obj.obj_num
     and (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, FHTV.OBJ_NUM
, VALUE(MVLV)
, VALUE(FHTV)
FROM OBJ$ O
, USER$ U
, SYS.KU$_FHTABLE_VIEW FHTV
, KU$_M_VIEW_LOG_VIEW MVLV
WHERE MVLV.MOWNER = U.NAME
AND MVLV.LOG = O.NAME
AND O.OWNER# = U.USER#
AND O.TYPE# = 2
AND O.OBJ# = FHTV.SCHEMA_OBJ.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (U.USER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))