Column UPDATE permission required when updating only variable - by Đonny

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 770615 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/9/2012 7:35:58 AM
Access Restriction Public


When an UPDATE statement updates a variable it requires column update permissions.
Sign in to post a comment.
Posted by ellight1 on 11/20/2012 at 6:00 AM
Construction of expression acceptable, function Column_Updated() returns the correct set of columns, but that seems illogical to check rights, as if all the columns are updated.

And what are the ways to change RowVersion, when no any other column can be changing (but updating referenced data, for example)?
Posted by Đonny on 11/19/2012 at 4:02 PM
Entity Framework generates this strange query. I had had no idea that this is a valid syntax before we changed some permissions, EF stopped working and I started investigating.
Posted by Microsoft on 11/19/2012 at 2:55 PM
Hi Donny,

Would you first mind explaining why you are using the "set @p=0" within an UPDATE statement rather than just using it as it's own statement? Thanks.