InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 00:00:53 GMT20http://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxIt always amazes me how many people think only in terms of GRANT and DENY. Great question.Tue, 30 Mar 2010 10:26:15 GMTPaul Whitehttp://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxNicely worded question as a DENY is used to override any non-explicit permission. Another excellent example for my class! :)Mon, 15 Mar 2010 21:53:13 GMTPeter Trasthttp://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxGood question..looking at few QotD last few days...ThanksSun, 24 Jan 2010 22:40:20 GMTjshailendrahttp://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxThe REVOKE statement can be used to remove granted permissions, Grant statement Granting ALL is equivalent to granting the permissionsDENY statement can be used to prevent a principal from gaining a specific permission through a GRANT.it was a better question than old past two days..!Keep like this going on ..Fri, 22 Jan 2010 02:06:34 GMTSree Arjun Divhttp://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxthis was a better question than the previous one... i m happy to get this one right :-DFri, 22 Jan 2010 01:33:15 GMTziangijhttp://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxNice question. :cool:Must admit I had to go to BOL to check on what I believed to be the answer (I was right!).Fri, 22 Jan 2010 01:31:39 GMTKelsey Thorntonhttp://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxI thought it helpful to add the following from MSDN[quote]The REVOKE statement can be used to [i][b]remove granted permissions[/b][/i], and the DENY statement can be used to [b][i]prevent a principal from gaining a specific permission through a GRANT[/i][/b].[/quote]This would further help clarify the difference between GRANT and DENY - hopefully.Fri, 22 Jan 2010 00:42:54 GMTSaurabh Dwivedyhttp://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxThanks for the question. It was a pleasure to answer it.Thu, 21 Jan 2010 22:10:38 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic851695-1228-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Security/68576/">Removing permissions</A>[/B]Thu, 21 Jan 2010 20:15:16 GMTkevriley