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.
Make sure your user ID has DBA authority.
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.
Close the database server to ensure the log file is available.
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).