Report SQL SERVER 2005 Permissions

Question

Post reply

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jim Russell-390299 SSCrazy Eights Points: 9333 More actions · Answer 1

Jim Russell-390299

SSCrazy Eights

Points: 9333

April 17, 2008 at 4:48 am

#803575

Revealing. Thanks!

Art Sennholtz Old Hand Points: 355 More actions · Answer 2

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

Art

mskd SSC Rookie Points: 29 More actions · Answer 3

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

ses2032 Grasshopper Points: 23 More actions · Answer 4

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

Howard C. BAchtel-438731 SSCrazy Points: 2384 More actions · Answer 5

Howard C. BAchtel-438731

SSCrazy

Points: 2384

June 30, 2010 at 11:29 am

#1187243

Thanks. This has save me considerable time.

fahey.jonathan Hall of Fame Points: 3617 More actions · Answer 6

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 · Answer 7

akljfhnlaflkj

SSC Guru

Points: 76202

May 11, 2016 at 11:41 am

#1878338

Thanks for the script.