Previous Topic: Define an SQL Server Server AuditNext Topic: Define a SQL Server Certificate

Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Property Editors › SQL Server Property Editors › SQL Server Audit Specifications › Define an SQL Server - Server Audit Specification

Define an SQL Server - Server Audit Specification

Use the SQL Server Server Audit Specification Editor in a SQL Server 2008, 2012, 2014, or 2016 physical model to define a SQL Server Audit Specification object using the SQL Server Audit feature. The object defines which actions on the server instance to audit and for whom.

To define a SQL Server server audit specification

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

    The SQL Server Server Audit Specification Editor opens.

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

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

    Name

    Specifies the name of the server audit specification. You can change the name of the server audit specification in this field.

    Server Audit

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

    Enabled

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

    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 server level auditable actions. Select each group that you want to audit.

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

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