Contents Index An auditing example Running the database server in a secure fashion

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

Auditing actions outside the database server


Some database utilities act on the database file directly. In a secure environment, only trusted users should have access to the database files.

To provide auditing of actions, under Windows NT only, any use of dbtran, dbwrite, and dblog generates a text file in the same directory as the database file, with the extension .alg. For example, for asademo.db, the file is called asademo.alg. Records containing the tool name, Windows user name, and date/time are appended to this file. Records are only added to the .alg file if the AUDITING option is set to ON.


Contents Index An auditing example Running the database server in a secure fashion