SQL Anywhere® Server - Database Administration  > Keeping Your Data Secure  > Auditing database activity

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:

• -d  Display output in chronological order.

• -t  Include trigger-generated operations in the output.

• -a  Include rolled back transactions in the output.

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.

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

For more information, see Log Translation utility (dbtran).

---