VIEW: SYS.KU$_MONITOR_VIEW

Source

View Text - Preformatted

select '1','0',
         o.obj_num,
         value(o),
         decode(bitand(nvl(t.flags, 0), 2097152), 2097152, 1, 0)
  from ku$_schemaobj_view o, sys.tab$ t
  where   t.obj# = o.obj_num and bitand(nvl(t.flags, 0), 2097152) != 0
        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 '1'
, '0'
, O.OBJ_NUM
, VALUE(O)
, DECODE(BITAND(NVL(T.FLAGS
, 0)
, 2097152)
, 2097152
, 1
, 0)
FROM KU$_SCHEMAOBJ_VIEW O
, SYS.TAB$ T
WHERE T.OBJ# = O.OBJ_NUM
AND BITAND(NVL(T.FLAGS
, 0)
, 2097152) != 0
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))