How do I make the users group i.e. domainname\users to be able to only select from tableA but user1 and user2 to have full control on it?
Note that user1 and user2 are already in domainname\users
1. Grant domainname\users select permissions on TableA.
2. Grant user1 and user2 full control on TableA OR
Create new group, add user1 and user2 into the group and grant this new group full control on