I only give a user permission to update and connect to the database and I get an error that I need select permission as well when I run an update. Is this normal? I also have the same issue with delete permission and needing select permission. Thanks for any help you provide.
This is not normal. I am not able to reproduce your problem. I created a table in one of my databases, created a login, added the login to the database, granted update to the new table and then logged in with my new user and was able to update the table without any other permissions.
This would give me permissions to insert, delete, select, and update but I am trying to limit permission. The reason behind this is to help prevent from sql injection on our website.
sodeep, your first question wasn't clear. He interpreted your question to mean "are you getting the error on all objects", whereas your question was "do you want the permissions on all objects". Next time, be more clear.
Update permission
Posted - 05/12/2008 : 16:18:59
