select '2','1',
mvv.sowner,
mvv.vname,
value(mvv),
value(pfhtv),
cast(multiset(select value(iv) from sys.ku$_all_index_view iv, sys.ind$ i
where i.bo# = ot.obj# and
bitand(i.property,8192) = 8192 and
iv.obj_num = i.obj#) as ku$_index_list_t)
from sys.obj$ ot, sys.user$ u, sys.ku$_pfhtable_view pfhtv,
sys.ku$_zm_view_view mvv
where ot.name = mvv.tname
and ot.owner# = u.user#
and u.name = mvv.sowner
and ot.type# = 2
and pfhtv.obj_num = ot.obj#
and BITAND(mvv.flag,33554432) != 33554432
and (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (ot.owner#, 0) OR
EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT '2'
, '1'
,
MVV.SOWNER
,
MVV.VNAME
,
VALUE(MVV)
,
VALUE(PFHTV)
,
CAST(MULTISET(SELECT VALUE(IV)
FROM SYS.KU$_ALL_INDEX_VIEW IV
, SYS.IND$ I
WHERE I.BO# = OT.OBJ# AND
BITAND(I.PROPERTY
, 8192) = 8192 AND
IV.OBJ_NUM = I.OBJ#) AS KU$_INDEX_LIST_T)
FROM SYS.OBJ$ OT
, SYS.USER$ U
, SYS.KU$_PFHTABLE_VIEW PFHTV
,
SYS.KU$_ZM_VIEW_VIEW MVV
WHERE OT.NAME = MVV.TNAME
AND OT.OWNER# = U.USER#
AND U.NAME = MVV.SOWNER
AND OT.TYPE# = 2
AND PFHTV.OBJ_NUM = OT.OBJ#
AND BITAND(MVV.FLAG
, 33554432) != 33554432
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (OT.OWNER#
, 0) OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|