Removing permissions
-
Comments posted to this topic are about the item Removing permissions
-
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 -
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...
Be Happy!
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
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 -
this was a better question than the previous one... i m happy to get this one right
-
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 ..
-
Good question..looking at few QotD last few days...Thanks
-
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 -
It always amazes me how many people think only in terms of GRANT and DENY. Great question.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply