select '1','0',
value(sov),
rc.obj# ,rc.ns ,rc.attr
from ku$_edition_schemaobj_view sov, sys.rls_ctx$ rc
where rc.obj# = sov.obj_num
and (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0 OR
EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT '1'
, '0'
,
VALUE(SOV)
,
RC.OBJ#
, RC.NS
, RC.ATTR
FROM KU$_EDITION_SCHEMAOBJ_VIEW SOV
, SYS.RLS_CTX$ RC
WHERE RC.OBJ# = SOV.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|