VIEW: SYS.KU$_OPERATOR_VIEW

Source

View Text - Preformatted

select '1','0',
         op.obj#, value(o), op.property,
         cast(multiset(select value(ob) from ku$_opbinding_view ob
                       where ob.obj_num=op.obj#
                       order by ob.bind_num
                      ) as ku$_opbinding_list_t
             )
  from  ku$_schemaobj_view o, sys.operator$ op
  where op.obj#=o.obj_num
        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'
, OP.OBJ#
, VALUE(O)
, OP.PROPERTY
, CAST(MULTISET(SELECT VALUE(OB)
FROM KU$_OPBINDING_VIEW OB
WHERE OB.OBJ_NUM=OP.OBJ# ORDER BY OB.BIND_NUM ) AS KU$_OPBINDING_LIST_T )
FROM KU$_SCHEMAOBJ_VIEW O
, SYS.OPERATOR$ OP
WHERE OP.OBJ#=O.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))