You can use Sybase Central to retrieve audit information from the transaction log.
You must have the BACKUP DATABASE system privilege to retrieve auditing information from a running database server. No privileges are required to retrieve auditing information from a database transaction log file.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, select the database.
In the right pane, click the Auditing tab.
Click Retrieve Audit Messages.
A window appears displaying the dbtran messages. Ignore the warning about chronological ordered output.
The auditing information appears in the Auditing tab.
Use the filter options to control which audit information you want to display.
You can choose to display all audit information, to show only errors, or to show only audit messages containing the text you specify. Click Apply to apply the filtering options.
Select an entry in the audit entries table to display details about the entry.
To retrieve up-to-date auditing information, press F5 and repeat this procedure.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|