SQL Anywhere Studio Security Guide
Keeping Your Data Secure
Auditing database activity
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
Ensure that your database is upgraded to at least version 6.0.2.
If you had to upgrade your database, create a new transaction log.
Execute the following statement:
SET OPTION PUBLIC.AUDITING = 'ON'
For more information, see AUDITING option [database].