Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2012 Property Editors › Define a SQL Server 2012 Database Audit Specification

Define a SQL Server 2012 Database Audit Specification

The SQL Server Database Audit Specification object collects a single instance of server or database-level actions and groups of actions to monitor. The Database Audit Specification object also belongs to a SQL Server Audit. You can create one database audit specification per SQL Server database per audit.

Use the SQL Server Database Audit Specification Editor in a SQL Server 2012 physical model to define the database actions to audit.

To define a SQL Server database audit specification

1. Click Target - SQL Server, Database Audit Specifications on the Model menu.

   The SQL Server Database Audit Specification Editor opens.

2. Select the database audit specification in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new database audit specification. Use the Enter filter text box to filter a very large list of database audit specifications to quickly locate the one that you want to define.

   Name

   Specifies the name of the database audit specification. Change the name of the database audit specification in this field.

   Enabled

   Specifies to enable the collection of records of database actions for auditing.

   Server Audit

   Specifies the name of the audit to which the selected specification applies.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and work with the following options:

   Audit Action Groups

   Displays the available groups of auditable actions. Select each group that you want to audit.

   Database Audit Actions

   Displays the available auditable actions and lets you specify the SQL Server principal on which to apply the audit action or audit action group.

   Note: Click the button to open the SQL Server Database Audit Action Editor to create or edit a database audit action.

4. (Optional) Click the Comment tab and enter any comments that you want to associate with the database audit specification.
5. (Optional) Click the UDP tab to work with user-defined properties for the database audit specification.
6. (Optional) Click the Notes tab to view history information and view or edit user notes.
7. Click Close.

   The database audit specification is defined and the SQL Server Database Audit Specification Editor closes.