SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Idera SQL Check

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.

Duration:
4 mins 17 secs
Skill Level:
100
Rating:
4.32 out of 5
Publish Date:
December 15, 2008
The difference between GRANT, DENY and REVOKE in SQL Server You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of K. Brian Kelley
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...

References

There are no downloads or recommended reading links for this video

Comments
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

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

Claudia on 11/17/2010
clear and directly.

Keith Badeau on 4/18/2011
Short and to the point, explains exactly what the video's title states.

John O'Sullivan on 7/22/2011
a very useful tip

Charlie Bruno on 7/22/2011
Below is the cut/pasted answer that was noted as correct. I believe "REMOVE" should be "REVOKE". On that basis this answer should be incorrrect. "REMOVE removes a permission, DENY guarantees that the user can no longer perform the action (Correct Answer)"

Gary Wilson on 7/22/2011
Correct answer to question one should say Revoke instead of Remove.

Matt on 7/22/2011
spelling error in the correct answer for question 1. The word REMOVE should be REVOKE.

stan on 7/22/2011
in your answers, you have REMOVE instead of REVOKE for 1.b

Richard H. Lang II on 7/22/2011
In the quiz, the first question, I think the second answer should read REVOKE instead of Remove.

Steven Costello on 7/22/2011
Enjoyed it! Easy to follow and provided really good explanations.

robert on 7/22/2011
Typo in this question: "REMOVE removes a permission, DENY guarantees that the user can no longer perform the action (Correct Answer)" should say REVOKE

WChaster on 7/22/2011
Your test is flawed!

Douglas Duncan on 7/23/2011
Showing the results of the query and the graphical properties after every run of the grant/deny/revoke queries was overkill and only the results of the query would have been sufficient to get your point across after the first or second run.

Munna Bhai on 7/23/2011
Excellent explanation!Thank you for sharing the video and keep up the good work.

Carol Green on 7/25/2011
Question 1 suggests using the REMOVE command - shouldn't that be REVOKE?

DavidB on 7/25/2011
The first question was worded incorrectly. The first word in that question should be REVOKE not REMOVE.

Eric on 7/25/2011
Excellent explanation, and simple, too! It would have helped me to see the "create login" and "create user" scripts that are necessary to for the SQL Server login account, but I eventually figured it out.

Audrey Michiels on 7/25/2011
After the test, I was asked the follwing question: >What is the difference between REVOKE and DENY? *REVOKE is a superset of DENY, both remove the ability to do some action *REMOVE removes a permission, DENY guarantees that the user can no longer perform the action (Correct Answer) *DENY removes a permission, REVOKE guarantees that the user can no longer perform the action *They are the same action, REVOKE is the preferred syntax. Note the 2nd answer uses the key work "REMOVE" which should be "REVOKE"

Saied Fatehi on 7/26/2011
It would have been even better lesson if the video also talk about "With Grant". I'm still thankful. Please also note that the first question of the quiz has a mistake in it. "REMOVE" should read "REVOKE" IMHO. Great job and thank you again. Saied

PHXHoward on 7/26/2011
The quiz at the end has the word REMOVE instead of REVOKE for the correct answer.

Doug Williamson on 7/27/2011
In the first question: the "correct" answer refers to a permission called "remove": should this have been "revoke" ? I thought it was a trick question.

Harit Patel on 7/28/2011
Very good one. Looking forward for few mores. That would be great if you can put some video regarding to Replicaiton

Nilesh on 8/2/2011
nice

Lee Linares on 11/1/2011
The 1st quiz question at the end indicates #2 as correct answer but there is NO such thing as a REMOVE command. It should read REVOKE.

Jon Guetlein on 11/1/2011
Your test needs to be corrected. It asks about REMOVE not REVOKE.

Maurice Ivory on 12/12/2011
I got some good information here, I got tripped up when the word remove was used. In the video remove was not used only Deny and revoke.

Mark on 12/22/2011
What is REMOVE permission ??? There is not such thing !

mahaboob on 2/14/2012
very good video for beginners. can you please provide video for schema also

m70 on 3/12/2012
Unnecessary repetitions

matt on 6/8/2012
Please correct typos!

DeVon Doman on 7/25/2012
Video was very explicit. The little quiz after the video is incorrect. The "correct" uses the syntax "REMOVE" instead of "REVOKE". Hence, the correct answer is incorrect.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions