Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»

Dump SQL Permissions Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2007 10:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:38 PM
Points: 5, Visits: 354
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!
Post #421690
Posted Tuesday, November 13, 2007 4:01 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:01 AM
Points: 258, Visits: 701
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



Post #421825
Posted Thursday, June 12, 2008 3:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Post #515751
Posted Tuesday, July 15, 2008 1:06 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:01 AM
Points: 258, Visits: 701
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




Post #534698
Posted Monday, June 15, 2009 1:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 15, 2009 1:05 PM
Points: 1, Visits: 0
Where can I download Dumpsqlsec?
Post #735261
Posted Monday, June 15, 2009 5:14 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:01 AM
Points: 258, Visits: 701
See links at bottom of article


Post #735377
Posted Tuesday, April 13, 2010 1:00 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 1,797, Visits: 2,171
I was just about to roll my own when I came across this looking for an updated version of DumpSec. Thank you, Thank you, Thank You

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Post #902700
Posted Tuesday, February 8, 2011 7:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 8, 2011 7:43 AM
Points: 1, Visits: 0
what version of client tools does it need?
Post #1060223
Posted Tuesday, February 8, 2011 3:59 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:01 AM
Points: 258, Visits: 701
The solution relies on SQL-DMO and Excel. SQL-DMO is deprecated class for managing SQL Server. SQL-DMO is install with SQL Server 2000, but not with SQL Server 2005 or higher. You can install SQL-DMO from by downloading the "Microsoft SQL Server 2005 Backward Compatibility Components" from Microsoft Downloads. This download might be available for SQL Server 2008 also.


Post #1060721
Posted Tuesday, June 14, 2011 12:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 16, 2012 11:21 PM
Points: 1, Visits: 89
Excelent tool! nice work... any version for SQL Server 2005? Thanks!
Post #1125270
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse