Report SQL SERVER 2005 Permissions

• stumbling fish

  SSC Enthusiast

  Points: 166

  More actions

  February 26, 2008 at 5:42 am

  #203675

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

• Jim Russell-390299

  SSCrazy Eights

  Points: 9333

  More actions

  April 17, 2008 at 4:48 am

  #803575

  Revealing. Thanks!

• Art Sennholtz

  Old Hand

  Points: 355

  More actions

  April 17, 2008 at 6:38 am

  #803650

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

  Art

• mskd

  SSC Rookie

  Points: 29

  More actions

  July 7, 2009 at 12:32 pm

  #1021270

  Nice script. It helps a lot in my SOX reporting..Thanks

• ses2032

  Grasshopper

  Points: 23

  More actions

  November 30, 2009 at 6:32 am

  #1085363

  Thanks!! very usefeul. Saved me a lot of time scripting an reporting.

• Howard C. BAchtel-438731

  SSCrazy

  Points: 2384

  More actions

  June 30, 2010 at 11:29 am

  #1187243

  Thanks. This has save me considerable time.

• fahey.jonathan

  Hall of Fame

  Points: 3617

  More actions

  December 13, 2011 at 11:11 am

  #1420769

  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.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 11, 2016 at 11:41 am

  #1878338

  Thanks for the script.