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';