SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Mani Singh / Column Level Permissions / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:37:25 GMT20RE: Column Level Permissionshttp://www.sqlservercentral.com/Forums/Topic514565-1313-1.aspxMissing brackets in DENY example. The correct syntax is:[code]DENY SELECT (<Column1>) ON Employees TO [MyDOMAIN\Mani][/code]LaccWed, 27 May 2009 02:38:02 GMTLaccColumn Level Permissionshttp://www.sqlservercentral.com/Forums/Topic514565-1313-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/63398/">Column Level Permissions</A>[/B]Tue, 10 Jun 2008 09:35:44 GMTMannySingh