Writes application audit events to an audit-enabled database.

Note: For more information about auditing, see Learn about Security and Auditing. For more information about enabling a database for auditing, see Manage the OpenEdge Database.

Syntax

AUDIT INSERT 
(event_id,
  [event_context |NULL ] 
  [event_detail |NULL ]);

Parameters

event_id

Positive integer value corresponding to an audit event record. The event_id must be a value greater than 32000.

event_context

Free-form character value that qualifies the event_id. May include non-ASCIIcharacters.

event_detail

Free-form character value that supplies detailed information about the audit event. May include non-ASCIIcharacters.

Notes

  • Before inserting the specified application audit event into the database, the OpenEdge SQL engine determines the following:
    • The connected user has been granted the audit insert privilege.
    • The event id is valid and active.

    If both of these conditions are true, the engine writes the application audit event to the database. If one or both are not true, the engine does not write the event.

  • AUDIT INSERT always returns a success status. This prevents users from determining whether or not they have privileges to log application audit events.