Removing permissions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Kev Riley » Removing permissions

Removing permissions

Rate Topic

Display Mode

Topic Options

Author

Message

kevriley

Posted Thursday, January 21, 2010 8:15 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677, Visits: 2,273

Comments posted to this topic are about the item Removing permissions

Post #851695

SQLRNNR

Posted Thursday, January 21, 2010 10:10 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

Thanks for the question. It was a pleasure to answer it.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #851719

Saurabh Dwivedy

Posted Friday, January 22, 2010 12:42 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, January 05, 2012 2:05 AM
Points: 488, Visits: 335

I thought it helpful to add the following from MSDN

The REVOKE statement can be used to remove granted permissions, and the DENY statement can be used to prevent a principal from gaining a specific permission through a GRANT.

This would further help clarify the difference between GRANT and DENY - hopefully.

Saurabh Dwivedy
___________________________________________________________

My Blog: http://tinyurl.com/dwivedys

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537

Be Happy!

Post #851781

Kelsey Thornton

Posted Friday, January 22, 2010 1:31 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, March 04, 2013 4:10 AM
Points: 532, Visits: 281

Nice question. Cool

Must admit I had to go to BOL to check on what I believed to be the answer (I was right!).

Kelsey Thornton
MBCS CITP

Post #851798

ziangij

Posted Friday, January 22, 2010 1:33 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,530, Visits: 359

this was a better question than the previous one... i m happy to get this one right BigGrin

Post #851800

Sree Arjun Div

Posted Friday, January 22, 2010 2:06 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:44 AM
Points: 2,173, Visits: 1,350

The REVOKE statement can be used to remove granted permissions,

Grant statement Granting ALL is equivalent to granting the permissions

DENY 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 ..

Post #851823

jshailendra

Posted Sunday, January 24, 2010 10:40 PM

Old Hand

Group: General Forum Members
Last Login: Friday, December 21, 2012 5:24 AM
Points: 366, Visits: 436

Good question..looking at few QotD last few days...Thanks

Post #852834

Peter Trast

Posted Monday, March 15, 2010 9:53 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594, Visits: 654

Nicely worded question as a DENY is used to override any non-explicit permission. Another excellent example for my class! :)

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

Post #883531

Paul White

Posted Tuesday, March 30, 2010 10:26 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 10,990, Visits: 10,540

It always amazes me how many people think only in terms of GRANT and DENY. Great question.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #893024

« Prev Topic | Next Topic »

Permissions