VIEW: SYS.KU$_CREDENTIAL_VIEW

Source

View Text - Preformatted

select '1','0',
         c.obj#, value(o),
         c.password,
         c.domain,
         c.flags
  from sys.ku$_schemaobj_view o, sys.scheduler$_credential c
  where o.type_num=90 AND
        c.obj# = o.obj_num AND
        (SYS_CONTEXT('USERENV','CURRENT_USER') IN (o.owner_name, 'SYS') OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, C.OBJ#
, VALUE(O)
, C.PASSWORD
, C.DOMAIN
, C.FLAGS
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.SCHEDULER$_CREDENTIAL C
WHERE O.TYPE_NUM=90 AND C.OBJ# = O.OBJ_NUM AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USER') IN (O.OWNER_NAME
, 'SYS') OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))