Retrieving auditing information (Sybase Central)

You can use Sybase Central to retrieve audit information from the transaction log.

Prerequisites

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.

Task

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.
Click Close.

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.

Results

Auditing information is retrieved.

Retrieving auditing information (Sybase Central)

Task

See also