Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report SQL SERVER 2005 Permissions Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2008 5:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 11, 2016 5:44 PM
Points: 46, Visits: 143
Comments posted to this topic are about the item Report SQL SERVER 2005 Permissions
Post #460164
Posted Thursday, April 17, 2008 4:48 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 30, 2010 11:27 AM
Points: 435, Visits: 1,403
Revealing. Thanks!
Post #486273
Posted Thursday, April 17, 2008 6:38 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 23, 2015 8:30 AM
Points: 25, Visits: 265
Nice script! Very helpful when looking for wayward permissions also! Thanks!
Art
Post #486358
Posted Tuesday, July 7, 2009 12:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 25, 2013 5:14 PM
Points: 1, Visits: 36
Nice script. It helps a lot in my SOX reporting..Thanks
Post #748788
Posted Monday, November 30, 2009 6:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 30, 2009 6:30 AM
Points: 1, Visits: 0
Thanks!! very usefeul. Saved me a lot of time scripting an reporting.
Post #826152
Posted Wednesday, June 30, 2010 11:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 25, 2015 1:23 PM
Points: 96, Visits: 391
Thanks. This has save me considerable time.
Post #945676
Posted Tuesday, December 13, 2011 11:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 11, 2016 3:37 PM
Points: 108, Visits: 392
This is a very helpful script. Thank you for posting it.

I am getting several blank lines in the output. It occurs when the "class" column of table "database_permissions" is 6, which Books Online defines as "6 = Type". The output handles only classes 0 and 3 specifically, while all other classess go through the default code. Perhaps this section needs to be reviewed.
Post #1221073
Posted Wednesday, May 11, 2016 11:41 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 8,328, Visits: 858
Thanks for the script.
Post #1785371
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse