What are included in SQL Server 2008 for automatic auditing

Question

What are included in SQL Server 2008 for automatic auditing?

Answer 1

This automatic auditing in SQL server 2008 include as given below:

• Provision for the centralized audit logs’ storage as well as integration along with system center

• Good performance which is noticeable

• Allows free-grained auditing wherein an audit can be targeted for several specific actions by a principle against an exact object.

• Allows the objects of audit to be function as first class database objects that mean Transact-SQL DDL statements can create such objects.

• The database object is controlled through database engine’s enforcement control and permission model.

• A new level permission is characteristic in SQL Audit – CHANGE ANY SERVER AUDIT- that permits a principle to ALTER, DROP and CREATE an Audit Specification object.

• A database level permission as: ALTER ANY DATABASE AUDIT; all is introduced to permit a principle to CREATE, DROP and ALTER a Database requirement object.