I'm using sql 2008 and I'm trying to set NT permissions to tables in Server Management Studio. I have a user group that needs read only and individual groups that need modify.
Everyone is part of the user group and if your not part of an individual group they only have read only.
The problem I'm having is if you're part of an individual group you have modify access to the entire database. Example, I have an tblArt. In the permissions for tblArt I have added the Art Group and given them permission to Insert, Select and Update. Not
only does this give them modify access to tblArt but modify access to all the other tables even though the Art Group is only part of tblArt.
What do I need to do to limit the group permissions to the individual tables?
View Complete Post