Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## AUDIT SET

> Allows grouping of audit data by the client on a per-connection basis.

> For more information about auditing, see OpenEdge Getting Started: Core Business Services . For more information about enabling a database for auditing, see OpenEdge Data Management: Database Administration .

> #### Syntax

>     AUDIT SET [ EVENT_GROUP | APPLICATION_CONTEXT ] [ string | NULL ];

> `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 that qualifies the event group or application context.

> `NULL`

> Clears an event group or application context string.

> Examples

> In this example, an application context is set:

>     AUDIT SET APPLICATION_CONTEXT ’06/02/2005 Deposits’;

> In this example, the application context is cleared:

>     AUDIT SET APPLICATION_CONTEXT NULL;

> #### Note

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

> ##### Authorization

> Must have `AUDIT_ADMIN`, `AUDIT_ARCHIVE`, or `AUDIT_INSERT` privileges.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095