Retrieving auditing information

You can use Sybase Central or the Log Translation utility (dbtran) to retrieve audit information from the transaction log. Before attempting to retrieve audit information, ensure that you are connected to your database as a user with DBA, Remote, or Backup authority.

 To retrieve auditing information (Sybase Central)
  1. Select the database.

  2. Click the Auditing tab.

  3. Click Retrieve Audit Messages.

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

  4. Click Close.

    The auditing information appears on the Auditing tab in the right pane.

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

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

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

For more information, see Auditing example.

 Retrieving auditing information using the dbtran utility