VIEW: SYS.KU$_JAVA_OBJNUM_VIEW

Source

View Text - Preformatted

select value(o) from ku$_schemaobj_view o
  where o.type_num in (28,29,30)
  and bitand(o.flags,16)!= 16       -- exclude secondary objects
 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$_SCHEMAOBJ_VIEW O
WHERE O.TYPE_NUM IN (28
, 29
, 30)
AND BITAND(O.FLAGS
, 16)!= 16 -- EXCLUDE SECONDARY OBJECTS
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))