Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : AUDIT INSERT
 

AUDIT INSERT

Writes application audit events to an audit-enabled database.
Note: For more information about auditing, see OpenEdge Getting Started: Core Business Services - Security and Auditing. For more information about enabling a database for auditing, see OpenEdge Data Management: Database Administration.

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.