April 18, 2011 at 6:58 am
Hello,
i managed to have an AD group controled access to my server.
My only problem is the the set access right to securables dont see to work properly.
-added the $groupname as a server login
-added the $targetdb as default db for $groupname
-mapped $groupname to $targetdb (so $groupname appears as a db user in Mngmt Studio)
-set the securables in the db user to the desired settings (G:select on most table, Update on one and D to every other action on every other table)
but sadly, when i connect tothe DB with a user of $groupname i manage to update records in a table i shouldn't be authorized to... any idea ?
Thanks a lot for your help !
April 18, 2011 at 7:17 am
How silly of me i was connection with an accound that was DB owner so anything was granted to him. I changed the DBOwner to another account but now it's the other way around ... nothing is granded anymore, not even select.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply