select '1','0',
phtv.obj_num,
value(mvlv),
value(phtv)
from obj$ o, user$ u, sys.ku$_phtable_view phtv, 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# = phtv.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' ))
SELECT '1'
, '0'
,
PHTV.OBJ_NUM
,
VALUE(MVLV)
,
VALUE(PHTV)
FROM OBJ$ O
, USER$ U
, SYS.KU$_PHTABLE_VIEW PHTV
, 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# = PHTV.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' ))
|
|
|