I would like to have a login which is capable of accessing a specific schema but should be having only update access to 2/3 tables. Is it possible?
The Database runs on SQL Server 2008 R2. Kindly guide me if possible.
Here is an example script
And please remember that unless the user is some level of administrator,
Then nothing you can do will grant them update access until you REVOKE the DENY.
You could add the user to
Besides using the script (which is preferred in most cases), you can do the same in SQL Server Management Studio:
3 Open the Permissions tab
4 Click Search to find the user you want to grant permissions to
5 Select the specific permission and check the Grant box
Pretty much what Edward Dortland said. If I understand what you're wanting, you probably want to create the user, add them to the datareaders role on that database, and manually give them update on the tables you want them to update.