VIEW: SYS.KU$_OBJECT_ERROR_VIEW

Source

View Text - Preformatted

SELECT  u.name, o.name, e.error#
FROM   sys.error$ e, sys.obj$ o, sys.user$ u
WHERE o.owner# = u.user# and e.obj# = o.obj# and
      (SYS_CONTEXT('USERENV','CURRENT_USERID')=0
       OR EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, E.ERROR# FROM SYS.ERROR$ E
, SYS.OBJ$ O
, SYS.USER$ U WHERE O.OWNER# = U.USER#
AND E.OBJ# = O.OBJ# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')=0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))