Microsoft SQL Server 2012 Bible

Database Audit Specifications

Database Audit Specifications are created using the same UI dialog as the Server Audit Specification. Like the Server Audit Specification, there may be only one Database Audit Specification per Database, per SQL Audit. To create multiple Database Audit Specifications, there must be multiple SQL Audits — one per Database Audit Specification.

The critical point is that Database Audit Specifications can audit DML events such as select, insert, update, and delete, as shown in Figure 42.3. You can also see the list of possible Database Audit Action Types in the drop-down list.

Figure 42.3 This Database Audit Specification records every select statement executed by the dbo user in the AdventureWorks2012 database and passes the audit data to the SQL Server 2012 Bible SQL Audit bucket.

Beginning with SQL Server 2012, new audit groups exist that enable you to support the monitoring of contained database users.