Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » Data security » Database activity audits


Retrieving auditing information (Sybase Central)

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.

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, select the database.

  3. In the right pane, click the Auditing tab.

  4. Click Retrieve Audit Messages.

    A window appears displaying the dbtran messages. Ignore the warning about chronological ordered output.

  5. Click Close.

    The auditing information appears in the Auditing tab.

  6. 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.

  7. Select an entry in the audit entries table to display details about the entry.

  8. To retrieve up-to-date auditing information, press F5 and repeat this procedure.


Auditing information is retrieved.

 See also