VIEW: SYS.KU$_CONTEXT_VIEW

Source

View Text - Preformatted

select '1','0',
         c.obj#, value(o),
         c.schema, c.package, c.flags
  from   sys.ku$_schemaobj_view o, sys.context$ c
  where  o.obj_num = c.obj# AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0 OR
          SYS_CONTEXT('USERENV','SESSION_USER') = c.schema OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, C.OBJ#
, VALUE(O)
, C.SCHEMA
, C.PACKAGE
, C.FLAGS
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.CONTEXT$ C
WHERE O.OBJ_NUM = C.OBJ# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR SYS_CONTEXT('USERENV'
, 'SESSION_USER') = C.SCHEMA OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))