InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 08:46:49 GMT20http://www.sqlservercentral.com/Forums/Topic460164-669-1.aspxThis 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.Tue, 13 Dec 2011 11:11:05 GMTfahey.jonathanhttp://www.sqlservercentral.com/Forums/Topic460164-669-1.aspxThanks. This has save me considerable time.Wed, 30 Jun 2010 11:29:45 GMTHoward C. BAchtel-438731http://www.sqlservercentral.com/Forums/Topic460164-669-1.aspxThanks!! very usefeul. Saved me a lot of time scripting an reporting.Mon, 30 Nov 2009 06:32:46 GMTses2032http://www.sqlservercentral.com/Forums/Topic460164-669-1.aspxNice script. It helps a lot in my SOX reporting..ThanksTue, 07 Jul 2009 12:32:21 GMTmskdhttp://www.sqlservercentral.com/Forums/Topic460164-669-1.aspxNice script! Very helpful when looking for wayward permissions also! Thanks!ArtThu, 17 Apr 2008 06:38:34 GMTArt Sennholtzhttp://www.sqlservercentral.com/Forums/Topic460164-669-1.aspxRevealing. Thanks!Thu, 17 Apr 2008 04:48:50 GMTJim Russell-390299http://www.sqlservercentral.com/Forums/Topic460164-669-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Security/62372/">Report SQL SERVER 2005 Permissions</A>[/B]Tue, 26 Feb 2008 05:42:46 GMTstumbling fish