select '1','2',
oo.obj#,
value(o),
value(t),
(select value(tb) from ku$_type_body_view tb
where oo.name = tb.schema_obj.name
and o.owner_name = tb.schema_obj.owner_name)
from sys.obj$ oo, sys.ku$_edition_schemaobj_view o,
ku$_type_view t
where oo.type# = 13
and oo.obj# = o.obj_num
and oo.obj# = t.schema_obj.obj_num
AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT '1'
, '2'
,
OO.OBJ#
,
VALUE(O)
,
VALUE(T)
,
(SELECT VALUE(TB)
FROM KU$_TYPE_BODY_VIEW TB
WHERE OO.NAME = TB.SCHEMA_OBJ.NAME
AND O.OWNER_NAME = TB.SCHEMA_OBJ.OWNER_NAME)
FROM SYS.OBJ$ OO
, SYS.KU$_EDITION_SCHEMAOBJ_VIEW O
,
KU$_TYPE_VIEW T
WHERE OO.TYPE# = 13
AND OO.OBJ# = O.OBJ_NUM
AND OO.OBJ# = T.SCHEMA_OBJ.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|