SQL Anywhere Studio Security Guide
  Auditing

Enabling and disabling auditing

This page describes operation of Adaptive Server Anywhere in a manner equivalent to a C2-security-certified configuration. It does not provide general-purpose information on the topic.

Auditing is OFF when you create a database. However, you can enable and disable auditing using the auditing public option at any time.

To start auditing on a particular database

• Turn the option ON using the following SQL statement:

  SET OPTION public.auditing='on'

  Only users with DBA authority can set public options. Once this option has been turned on, all permission checks and connection attempts are audited.

To stop (disable) auditing on a particular database

• Turn the option OFF using the following SQL statement:

  SET OPTION public.auditing = 'off'

  Only a user with DBA authority can issue this statement.

For more information and a complete list of the types of audit records that the engine or server can generate, see Audit records.

Note 

Auditing is optional when running in a C2 certified configuration.