select '1','0',
oo.obj#,
oo.type#,
value(o),
(select value (c)
from ku$_switch_compiler_view c where c.obj_num = oo.obj#)
from sys.ku$_edition_schemaobj_view o, sys.obj$ oo
where oo.type# = 8
and oo.obj# = o.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'
, '0'
,
OO.OBJ#
,
OO.TYPE#
,
VALUE(O)
,
(SELECT VALUE (C)
FROM KU$_SWITCH_COMPILER_VIEW C
WHERE C.OBJ_NUM = OO.OBJ#)
FROM SYS.KU$_EDITION_SCHEMAOBJ_VIEW O
, SYS.OBJ$ OO
WHERE OO.TYPE# = 8
AND OO.OBJ# = O.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' ))
|
|
|