I have given one data base user read permission only, using
Now, I need to give the same user permission to update only one table (PROD.CustomerRelations).
Is there any way to give this permission ?
EDIT: I have tried the below method, but still I cannot update. I'm accessing SQL Server DB thru Microsoft Access.
I guess the above method does not work because I used
Insert in the screen
Database Properties -> Permissions -> Explicit permissions for [domain\user1]