Question

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.


Sponsored



Replies

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

http://www.mssqltips.com/sqlservertip/2894/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.!!!!!!!