You can use Sybase Central or the Log Translation utility (dbtran) to retrieve audit information from the transaction log.
Connect to the database as a user with DBA, Remote, or Backup authority.
Select the database.
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 on the Auditing tab in the right pane.
Use the filter options to control which audit information you want to display.
You can choose to display all audit information, or to show only errors, or only audit messages containing the text you specify.
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.
For more information, see Auditing example.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|