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

 

Configuring auditing (Interactive SQL)

You can use Interactive SQL to configure auditing for security-related information in the transaction log. Auditing is off by default.

Prérequis

You must have the SET ANY SECURITY OPTION system privilege.

 Task
  1. Connect to your database.

  2. Execute the following statement to turn on auditing:

    SET OPTION PUBLIC.auditing = 'On';

    To specify which types of auditing information you want to enable, use the following system procedure:

    CALL sa_enable_auditing_type( 'all' );

    You can control the type of auditing information that is collected by replacing all with the types of auditing you want to enable.

  3. Execute the following statement to turn off auditing:

    SET OPTION PUBLIC.auditing = 'Off';

    To specify which types of auditing information you want to disable, use the following system procedure:

    CALL sa_disable_auditing_type( 'all' );

    You can stop collecting specific types of auditing information by replacing all with the types of auditing you want to disable.

Résultat

The auditing behavior is configured.

 See also