Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Keeping Your Data Secure » Auditing database activity

Turning on auditing Next Page

Retrieving audit information

You can use the Log Translation (dbtran) utility to retrieve audit information. You can access this utility from Sybase Central or from a command prompt. The dbtran utility uses the specified transaction log to produce a SQL script that contains all of the transactions, along with some information on what user executed each command. By using the -g option, dbtran includes more comments containing the auditing information. The -g option automatically sets the following options:

You can run the Log Translation utility against a running database server or against a database log file.

To retrieve auditing information from a running database server
  1. Make sure your user ID has DBA authority.

  2. With the database server running, execute the following statement at a system command prompt:

    dbtran -g -c "UID=DBA;PWD=sql;..." -n demo.sql

    For more information about connection strings, see Connection parameters.

  3. To retrieve auditing information from a transaction log file
    1. Close the database server to ensure the log file is available.

    2. At a system command prompt, execute the following statement to place the information from the file demo.log and into the file demo.sql.

      dbtran -g demo.log
    3. For more information, see Log Translation utility (dbtran).