SLNSH on Tue, 19 Mar 2013 13:03:49

Hi all,

what is the difference between GRANT,REVOKE,DENY...?

please give me some examples. and detail information.



Uri Dimant on Tue, 19 Mar 2013 13:19:50

Each object has a list of rules DENYing and GRANTing access.

REVOKE is an operation that removes a rule from the list of access rules.

Rama Udaya on Mon, 25 Mar 2013 10:34:25

Understanding GRANT, DENY, and REVOKE in SQL Server

kumarpvk on Tue, 26 Mar 2013 14:19:21

Grant ->Giving access to objects.

Deny->Restricting access to objects.

Revoke->Removes assigned permission of an object.

Hope this helps.!!!!!!!