DBA Data[Home] [Help]

VIEW: SYS.KU$_RLS_CONTEXT_VIEW

Source

View Text - Preformatted

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' ))
View Text - HTML Formatted

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' ))