VIEW: SYS.KU$_AUDIT_OBJ_VIEW

Source

View Text - Preformatted

select value(ku$) from sys.ku$_audit_obj_base_view ku$
  where trim('-' from ku$.audit_val) IS NOT NULL
  and  (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (ku$.base_obj.owner_num, 0)
        OR    EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT VALUE(KU$)
FROM SYS.KU$_AUDIT_OBJ_BASE_VIEW KU$
WHERE TRIM('-'
FROM KU$.AUDIT_VAL) IS NOT NULL
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (KU$.BASE_OBJ.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))