VIEW: SYS.KU$_DOMIDX_OBJNUM_VIEW

Source

View Text - Preformatted

select i.obj#,NULL,
  NULL,NULL,                   -- property bits not needed
  NULL,                        -- ts# not needed
  value(o), value(bo)
  from ku$_schemaobj_view o, ku$_schemaobj_view bo, sys.ind$ i
  where o.obj_num=i.obj#
  and   bo.obj_num=i.bo#
  and   i.type#=9            /* domain index */
  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 I.OBJ#
, NULL
, NULL
, NULL
, -- PROPERTY BITS NOT NEEDED NULL
, -- TS# NOT NEEDED VALUE(O)
, VALUE(BO)
FROM KU$_SCHEMAOBJ_VIEW O
, KU$_SCHEMAOBJ_VIEW BO
, SYS.IND$ I
WHERE O.OBJ_NUM=I.OBJ#
AND BO.OBJ_NUM=I.BO#
AND I.TYPE#=9 /* DOMAIN INDEX */
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))