Database Auditing Specification
Database auditing is to audit database specific activities.
Similar to Server Audit Specification there is a new Database Auditing
Specification node below the DatabaseName -> Security node.
By right clicking and select new Database Auditing Specification,
you can create a Database Auditing Specification. Next select an appropriate
audit action group. The following list gives you the commonly used auditing
groups.
SELECT |
This event is raised whenever a SELECT |
UPDATE |
This event is raised whenever an |
INSERT |
This event is raised whenever an |
DELETE |
This event is raised whenever a DELETE |
EXECUTE |
This event is raised whenever an |
REFERENCES |
This event is raised whenever a |
Apart from the above list, all the groups in the Server
Audit Specifications which starts with DATABASE are available. The main
difference is that, Database Auditing Specification is for a given database
while Server Audit Specification is for an entire server.
|
As for Server Audit Specification, we create a Database Auditing
Specification from T-SQL.
The below is a screenshot of the data generated:
As with Server Auditing Specification, you need to enable Database
Auditing Specification and disable it if you need to alter or drop the Database
Auditing Specification.
Supported Editions
The Audit feature is supported only in Enterprise and
Developer editions of SQL Server 2008.
]]>