Ask Your Instructor: SQL Server Permissions

Peter,

I was a student in your May 24-26 class and was hoping that you could assist me with a sequel question.

In the SQL Server there is a section to set up users, groups and permissions. If there is a change in the permissions for a group, is there any way to research when this change took place and who updated the permissions?

Thanks for your consideration.

Tricia
----------------------------------------------------------------------------

Tricia,

Yes, there is a feature called SQL Server audit and I have a link to the MSDN webpage that explains it. The basic concept is to create an audit that can have one or more audit specifications assigned to it, enable the audit and the audit specs and track any type of activity that is available through audit specs.

http://msdn.microsoft.com/en-us/library/cc280663.aspx

This should get you started. We cover this briefly in Module 4 of the 6231 class which I am teaching June 28-July 2. We don’t spend a lot of time on it but you get to see it and try it, as well as learning many other aspects of maintaining SQL Server throughout the week.

Hope to see you there. Please feel free to ask any further questions!

- Peter Trast, SQL Expert; MCITP DBA, MCITP EA, MCT LinkIn with Peter