InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 08:57:42 GMT20http://www.sqlservercentral.com/Forums/Topic610114-371-1.aspxbrandie, a bit late perhaps but as you ask in the code column level permissions are in the minor_id column in sys.database_permissionsIf minor_id = 0 its not a column level permissions else it can be derived thuscol_name(sys.database_permissions.major_Id, sys.database_permissions.minor_id)Fri, 07 Oct 2011 10:29:56 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic610114-371-1.aspxDOH! Good catch, Jerry. I was so busy trying to make sure I didn't post code w/o permission that I must have accidently dropped that declare statement.My bad. :blush:Wed, 03 Dec 2008 04:54:47 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic610114-371-1.aspxThanks for the codeI think you missed the @DBName declaration at the top[code]Declare @sqlstmt varchar(5000);declare @DBName sysname;set @DBName = DB_NAME()set @sqlstmt = 'use ['+@DBName+']' + char(10) [/code]Fri, 28 Nov 2008 08:15:49 GMTJerry Hunghttp://www.sqlservercentral.com/Forums/Topic610114-371-1.aspxHey Brandie, thanks for posting the code.Fri, 28 Nov 2008 07:15:43 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic610114-371-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/64793/">SQL 2005 Get Roles, Schemas &amp; Object Permissions</A>[/B]Fri, 28 Nov 2008 00:02:53 GMTBrandie Tarvin