Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Removing permissions Expand / Collapse
Author
Message
Posted Thursday, January 21, 2010 8:15 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:35 AM
Points: 2,716, Visits: 2,471
Comments posted to this topic are about the item Removing permissions
Post #851695
Posted Thursday, January 21, 2010 10:10 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:54 AM
Points: 17,814, Visits: 15,740
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
Post #851719
Posted Friday, January 22, 2010 12:42 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 5, 2013 11:51 PM
Points: 488, Visits: 336
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
Posted Friday, January 22, 2010 1:31 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:16 AM
Points: 534, Visits: 282
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
Post #851798
Posted Friday, January 22, 2010 1:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 12:40 AM
Points: 2,063, Visits: 370
this was a better question than the previous one... i m happy to get this one right
Post #851800
Posted Friday, January 22, 2010 2:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:47 AM
Points: 2,296, Visits: 1,427
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
Posted Sunday, January 24, 2010 10:40 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 7:12 AM
Points: 366, Visits: 455
Good question..looking at few QotD last few days...Thanks
Post #852834
Posted Monday, March 15, 2010 9:53 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
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
Posted Tuesday, March 30, 2010 10:26 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, October 17, 2014 8:13 AM
Points: 9,926, Visits: 11,188
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 »

Add to briefcase

Permissions Expand / Collapse