Pro SQL Server 2012 Administration

C H A P T E R  14

Auditing SQL Server

Auditing your SQL Server is an important aspect of protecting your data. As a database administrator, you need to know the users who are logged into your system or attempting to log into your system, and what they are doing once they have gained access.

Auditing what users are doing in your system is less important when you have total control over their access within SQL Server. In other words, if you get to determine all users’ access and their permissions, then auditing your users is not as critical because you can restrict their permissions and ensure they perform only the actions that you trust them to perform. Unfortunately, most DBAs do not have total control; you have to give users the access the ...