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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Security » Keeping your data secure » Auditing database activity

 

Controlling auditing

The database administrator can turn on auditing to add security-related information to the transaction log. This can be done using Sybase Central or Interactive SQL.

Auditing is off by default. You must have DBA authority to enable and disable auditing.

 ♦  To control auditing (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. Right-click the database and choose Properties.

  3. Click the Auditing tab and choose one of the following:

    • Do Not Collect Audit Information For This Database   No audit information is collected. This option disables auditing by setting the auditing database option to Off. See auditing option.

    • Collect All Audit Information For This Database   All types of auditing information are collected for the database. This option enables auditing by setting the auditing database option to On. See auditing option.

      The transaction log can grow significantly when this option is selected.

    • Collect The Following Type(s) Of Audit Information For This Database   Allows you to specify which auditing information to collect. For example, you can choose to collect only DDL changes. See sa_enable_auditing_type system procedure. Selecting this option changes the setting of the auditing_options database option. See auditing_options option.

  4. Click OK.

 ♦  To control auditing (Interactive SQL)
  1. Connect to your database as a user with DBA authority.

  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. See sa_enable_auditing_type system procedure.

  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. See sa_disable_auditing_type system procedure.

 Auditing individual connections
 See also