Comments posted to this topic are about the item Removing permissions
Thanks for the question. It was a pleasure to answer it.
I have given a name to my pain...MCM SQL Server, MVP
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.
My Blog: http://tinyurl.com/dwivedys
For better, quicker answers, click on the following...
Nice question. 😎
Must admit I had to go to BOL to check on what I believed to be the answer (I was right!).
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! 🙂
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 8 (of 8 total)