VIEW: SYS.KU$_RLS_GROUP_VIEW

Source

View Text - Preformatted

select '1','0',
          value(sov),
          rg.obj# , rg.gname
  from    ku$_edition_schemaobj_view sov, sys.rls_grp$ rg
  where   rg.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)
, RG.OBJ#
, RG.GNAME
FROM KU$_EDITION_SCHEMAOBJ_VIEW SOV
, SYS.RLS_GRP$ RG
WHERE RG.OBJ# = SOV.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))