Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

auditing option

Enables and disables auditing in the database.

Allowed values

ON, OFF

Default

Off

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY SECURITY OPTION No No
Allowed to set temporarily? Yes, with SET ANY SECURITY OPTION No No
Remarks

This option turns auditing on and off.

Auditing is the recording of details about events in the database. Auditing provides some security features at a performance cost.

The following restrictions are in place when the audit log is set to the transaction log:

  • When you turn on auditing for a database, you cannot stop using the transaction log. In this case, you must turn off auditing before you turn off the transaction log.
  • Databases with auditing set to the transaction log cannot be started in read-only mode.

If you set the auditing option to On, and do not specify auditing options, then all types of auditing information are recorded. Alternatively, to control the type of information that you want to audit use the sa_enable_auditing_type and sa_disable_auditing_type system procedures.

Example

The following statement turns on auditing for the database.

SET OPTION PUBLIC.auditing = 'On';