ASA Database Administration Guide
  Database Options
    Alphabetical list of options

AUDITING option [database]

Function 

Enables and disables auditing in the database.

Allowed values 

ON, OFF

Scope 

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

Default 

OFF

See Also 

sa_enable_auditing_type

sa_disable_auditing_type

Description 

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 take place 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.

Example 

• Turn on auditing

  SET OPTION PUBLIC.AUDITING = 'ON'