AUDITING option [database]

Enables and disables auditing in the database.

ON, OFF

OFF

This option turns auditing on and off.

Auditing is the recording of detailed information about many events in the database in the transaction log. Auditing provides some security features, at the cost of some performance.

For the AUDITING option to work, you must set the AUDITING option to ON, and also specify which types of information you want to audit using the sa_enable_auditing_type system procedure. Auditing will not occur if either of the following are true:

• AUDITING is set to OFF

• Auditing options have been disabled

If you set AUDITING ON, and do not specify auditing options, all types of auditing information are recorded. Alternatively, you can choose to record any combination of the following: audit permission checks, connection attempts, DDL statements, public options, and triggers.

Can be set for the PUBLIC group only. Takes effect immediately. Requires DBA permissions to set this option.