Home Dashboard Directory Help
Search

Column UPDATE permission required when updating only variable by Đonny


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 770615
Opened: 11/9/2012 7:35:58 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

When an UPDATE statement updates a variable it requires column update permissions.
Details
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
Hello,
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.
Sign in to post a workaround.