Report SQL SERVER 2005 Permissions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Carley Zepeda » Report SQL SERVER 2005 Permissions

Report SQL SERVER 2005 Permissions

Rate Topic

Display Mode

Topic Options

Author

Message

stumbling fish

Posted Tuesday, February 26, 2008 5:42 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, August 16, 2012 7:39 AM
Points: 46, Visits: 142

Comments posted to this topic are about the item Report SQL SERVER 2005 Permissions

Post #460164

Jim Russell-390299

Posted Thursday, April 17, 2008 4:48 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, July 30, 2010 11:27 AM
Points: 435, Visits: 1,403

Revealing. Thanks!

Post #486273

Art Sennholtz

Posted Thursday, April 17, 2008 6:38 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 12:16 PM
Points: 25, Visits: 236

Nice script! Very helpful when looking for wayward permissions also! Thanks!
Art

Post #486358

mskd

Posted Tuesday, July 07, 2009 12:32 PM

Forum 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

ses2032

Posted Monday, November 30, 2009 6:32 AM

Forum 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

Howard C. BAchtel-438731

Posted Wednesday, June 30, 2010 11:29 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:54 PM
Points: 77, Visits: 301

Thanks. This has save me considerable time.

Post #945676

fahey.jonathan

Posted Tuesday, December 13, 2011 11:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 11, 2013 5:58 PM
Points: 100, Visits: 347

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

« Prev Topic | Next Topic »

Permissions