|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, March 08, 2010 7:18 AM
Points: 4,
Visits: 212
|
|
This is a great idea for a tool - kudos to the author!
I'm having a problem with it that is probably because of something I'm doing wrong - I thought that I'd throw it out there and see if anyone else had the same issue.
I have an ID that has been granted permission to update a specific column in a table and has no other rights in the table. The DumpSQLSec tool doesn't report any type of access for the ID in the table. It does seem to catch all other permissions for this ID that are granted in regards to entire tables. Is this a bug or is it me?
Thanks!
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 15, 2010 9:38 AM
Points: 236,
Visits: 534
|
|
You're right it doesn't handle column permissions, the code is iterating through by object type and then for each object (table,view, stored procedure, function) executing the ListPermissions method. It looks like column is another object in SQL-DMO. I'm currently working on a Powershell script which uses SMO, once its finished I'll write an article about it. The Powershell/SMO script will handle column permissions correctly.
--Chad
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Monday, June 15, 2009 11:15 PM
Points: 46,
Visits: 47
|
|
Hello Steve,
yes I would like to look at it. May I ask you to send it over to me?
With kind regards,
John
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 15, 2010 9:38 AM
Points: 236,
Visits: 534
|
|
All,
I've completed a part-time 9 month project to write a utility called "SQL Server PowerShell Extensions (SQLPSX) which uses SMO, PowerShell, and SSRS to produce permissions/security reports including effective permissions by enumerating nested Windows AD/local and SQL Server roles. SQLPSX can be scheduled to run in batch mode and loads the collected security information into a database for reporting and analysis. Check it out on my CodePlex project site.
http://www.codeplex.com/SQLPSX
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 15, 2009 1:05 PM
Points: 1,
Visits: 0
|
|
| Where can I download Dumpsqlsec?
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 15, 2010 9:38 AM
Points: 236,
Visits: 534
|
|
|
|
|
