February 17, 2011 at 9:10 am
what is the best tool in the market that can be used to monitor all acitvites of sql server like who changed what permissions and when.
February 17, 2011 at 9:16 am
Tara-1044200 (2/17/2011)
what is the best tool in the market that can be used to monitor all acitvites of sql server like who changed what permissions and when.
I would say SQL Server server-side traces are best suited to capture the information. They can be tedious to work through to determine who did what when you need to.
The default trace captures activities and can be easily queried from SSMS to pull out specific information.
I don't know that there are any 3rd party tools for security specifics information. There probably are some that help with change management.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 17, 2011 at 9:27 am
so how can i find who gave sysadmin previalges to X account from SSMS?
February 17, 2011 at 9:33 am
Default trace - A Beginner's Guide[/url]
The above SSC article should get you familiar with the script used. The Event ID you want to look for is 108. You can see this by checking available Event IDs in this BoL article.
You can also Bing for "query default trace" and it will probably give you some more examples to work from.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 17, 2011 at 9:37 am
Jack Corbett also has a video/slide deck from doing SQLLunch on hitting the default trace for information. The slide deck are linked hereon his blog. You can go to the SQLLunch site and I think the video is available to watch.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 17, 2011 at 1:57 pm
do you think ApexSQL or SQL Complaince managerv3.2 will give those options for me?
February 17, 2011 at 2:24 pm
Tara-1044200 (2/17/2011)
do you think ApexSQL or SQL Complaince managerv3.2 will give those options for me?
Just from brief read Apex SQL Log looks like it is could be what you are looking for. The Idera product looks good as well.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply