June 13, 2007 at 1:14 pm
Hi all:
Does anybody knows where can I get a tool (If free even better) to produce security reports. Reports that shows what ID's have access to what objects, and what kind of access they have been granted?.
The system tables are not very friendly to produce reports. Joins are a must, but I am at the end of my rope..... Please help.
Thanks
June 14, 2007 at 12:22 pm
Maybe this is not quite what you are looking for (though it might be) but it is a start.
sp_helprotect
http://msdn2.microsoft.com/en-us/library/ms190310(SQL.90).aspx
June 14, 2007 at 3:07 pm
SqlSpec will do this for you if you choose the "document permissions" option, or pass "/y 1" on the command line. Also the eval version is free. See the link in my sig for details.
---------------------------------------
elsasoft.org
June 14, 2007 at 3:50 pm
Not sure that sp_helpprotect will give the stats you're looking for. I haven't found a free one yet, most I've seen are about 1K + Here's a couple I've looked at...
Ben Sullins
bensullins.com
Beer is my primary key...
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply