The difference between GRANT, DENY and REVOKE in SQL Server

In this video Brian covers the differences between using GRANT, DENY and REVOKE when it comes to using them in SQL Server 2005.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

Mark Hodgson on 2/24/2009

Type in question 1!

Ed Svastits on 2/24/2009

Good examples. Kept to scope. Next video could go into resolving permission conflicts (tables and views and stored procedures, oh my).

wayne dismukes on 2/24/2009

Are you guys sure about the answer to question one?

Paul Woike on 2/24/2009

Great explanations of GRANT, DENNY and REVOKE

casey on 2/24/2009

great video

Dave Hozen on 2/24/2009

On the first question after the video, you have the word REMOVE and it should be REVOKE, looks like a typo

Chris Rock on 2/24/2009

Thank you for letting us know the answer was incorrect. We fixed the problem.

Chintak Chhapia on 2/24/2009

Good Video

yousef on 8/8/2009

what is the correct answer to this question ? I am completely confused."What is the difference between REVOKE and DENY? " I chose "REMOVE removes a permission, DENY guarantees that the user can no longer perform the action" which is item 2 ,though has a typo,But it said the correct answer is "DENY removes a permission, REVOKE guarantees that the user can no longer perform the action (Correct Answer)". If I answered the question correctly,please give back my score!

01EFFB45CF on 8/29/2009

I found a typo: "REMOVE removes a permission, DENY guarantees that the user can no longer perform the action (Correct Answer)" should be "REVOKE"

Mohamed Kaleel on 9/14/2009

typo error REMOVE instead of REVOKE

Señor Tone Checker on 9/15/2009

You have a typo in your first question: "REMOVE" should be "REVOKE". (My permanent record is marred due to this; I didn't choose that answer because of the typo! What will this do to my career?!?!)

urtzi on 10/4/2009

simple and practical!

JohnG on 10/29/2009

Good explanation of the 3.

Alireza on 10/29/2009

nice teaching thanks

Melanie on 11/5/2009

The second answer to the first question should state REVOKE removes...... instead of REMOVE removes........

Karim on 11/12/2009

Thanks

A Alagu Ganesh on 1/20/2010

Good

Bill Wu on 5/21/2010

I didn't know SQL has REMOVE

Gino on 6/6/2010

good