Removing permissions

Question

Removing permissions

Kev Riley

SSCrazy Eights

Points: 9075
More actions
January 21, 2010 at 8:15 pm

#215943

Comments posted to this topic are about the item Removing permissions

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Saurabh Dwivedy SSCommitted Points: 1887 More actions · Answer 2

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!

Kelsey Thornton SSCrazy Points: 2157 More actions · Answer 3

Nice question. 😎

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

ziangij SSCrazy Eights Points: 8066 More actions · Answer 4

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

Arjun SreeVastsva SSCertifiable Points: 7141 More actions · Answer 5

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

jshailendra SSCrazy Points: 2260 More actions · Answer 6

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

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 7

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

Paul White SSC Guru Points: 150467 More actions · Answer 8

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

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi