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

AUDIT SET

Allows grouping of audit data by the client on a per-connection basis.
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 SET { EVENT_GROUP | APPLICATION_CONTEXT }
{
string | NULL }, {string | NULL };

Parameters

EVENT_GROUP
Indicates that subsequent audit records written by the database engine during the current connection will be marked as part of an event group.
APPLICATION_CONTEXT
Indicates that subsequent audit records written by the database engine during the current connection will be saved with application context information.
string
Free-form character value which is a unique string identifier for the group/application context event.
NULL
Clears an event group or application context string.
string
Free-form character value which provides additional application detail that describes the group/application context.
NULL
Clears an event group or application context string.

Note

AUDIT SET always returns a success status. This prevents users from determining whether or not they have audit privileges.

Examples

Setting an application context
In this example, an application context is set:
AUDIT SET APPLICATION_CONTEXT 'app.name.checking' '06/02/2005 Deposits';
Clearing an application context
In this example, the application context is cleared:
AUDIT SET APPLICATION_CONTEXT NULL NULL;
* Authorization