What role or permission should a SQL user have in order to run a script that has a single UPDATE command like below?
Posted on 2016-08-26
We are running SQL 2008 R2 on a Windows 2008 R2 server.
I would like to know what role or permission a user should have in order to run a script that contains a single UPDATE command like the one shown below:
SET Column1 = ‘A’
WHERE Column2 = ‘XXXX’ AND Column1 = ‘B’
Attempting to run the query currently returns the following error:
The UPDATE permission was denied on the object ‘Table1’, database ‘DB1’, schema ‘dbo’.
Thanks in advance,