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. See auditing option [database].

  • 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. See auditing option [database].

  • 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. See auditing option [database] and sa_enable_auditing_type system procedure.

    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