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

SQL Anywhere 12.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows

 

Database Properties window: Auditing tab

This tab has the following components.

  • Do not collect audit information for this database   Select this option to disable auditing by setting the auditing database option to Off.

  • Collect all audit information for this database   Select this option to collect all types of auditing information for the database. This option enables auditing by setting the auditing database option to On. The transaction log can grow significantly when this option is selected.

  • Collect the following types of audit information for this database   Select this option to specify the types of auditing information to collect. Selecting this option changes the setting of the auditing_options database option and sets the sa_enable_auditing_type system procedure to the auditing types specified below.

    Select one or more of the following options:

    • Successful connections   Select this option to enable auditing of successful connections.

    • Failed connections   Select this option to enable auditing of failed connection attempts.

    • DDL changes   Select this option to enable auditing of DDL statements.

    • Option setting changes   Select this option to enable auditing of public options.

    • Permission checks   Select this option to enable auditing of permission checks, user checks, and SETUSER statements.

    • Denied permissions   Select this option to enable auditing of failed permission and user checks.

    • Triggers   Select this option to enable auditing after a trigger event.

 See also