VIEW: SYS.KU$_VIEW_OBJNUM_VIEW

Source

View Text - Preformatted

select value(o) from ku$_edition_schemaobj_view o, sys.view$ v
  where o.obj_num=v.obj#
  and not exists (SELECT 1 FROM SYS.OLAP_AW_VIEWS$ V
            WHERE O.OBJ_NUM = V.VIEW_OBJ# AND V.VIEW_TYPE = 1)
  AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0)
        OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT VALUE(O)
FROM KU$_EDITION_SCHEMAOBJ_VIEW O
, SYS.VIEW$ V
WHERE O.OBJ_NUM=V.OBJ#
AND NOT EXISTS (SELECT 1
FROM SYS.OLAP_AW_VIEWS$ V
WHERE O.OBJ_NUM = V.VIEW_OBJ#
AND V.VIEW_TYPE = 1)
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))