Contents Index Auditing database activity Retrieving audit information

SQL Anywhere Studio Security Guide
  Keeping Your Data Secure
    Auditing database activity

Turning on auditing


The database administrator can turn on auditing to add security-related information to the transaction log.

Auditing is off by default. To enable auditing on a database, the DBA must set the value of the public option AUDITING to ON. Auditing then remains enabled until explicitly disabled, by setting the value of the AUDITING option to OFF. You must have DBA permissions to set this option.

To turn on auditing

  1. Ensure that your database is upgraded to at least version 6.0.2.

  2. If you had to upgrade your database, create a new transaction log.

  3. Execute the following statement:

    SET OPTION PUBLIC.AUDITING = 'ON'

    For more information, see AUDITING option [database].


Contents Index Auditing database activity Retrieving audit information