March 26, 2010 at 2:01 pm
I would like to revoke access to all windows groups on a particular table but give read/write access to only 1 user and the problem is this user exists in some of those groups, how can i handle this.
March 26, 2010 at 6:51 pm
As long as you haven't given any of these groups special roles (sysadmin, db_owner, datareader, etc...), it shouldn't be that hard. Just like you said, first revoke ALL access to the table, then grant only that user access to the table. As long as you aren't using DENYs, or DB/Schema level GRANTs, and no one is dbo or sa, then that should work.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply