Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause [CORE3360] #3726

Closed
firebird-automations opened this issue Feb 24, 2011 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Raul Chirea (raul_chirea)

Is related to QA511

Attachments:
3360.sql

If a user who has permissions to select all columns in a table but to update only some columns, tries to prepare a statement like this:

"UPDATE THE_TABLE set WRITEABLE_COLUMN = 'something' where id = 11 RETURNING NON_WRITEABLE_COLUMN"

error -551 "no permission for update/write access to column NON_WRITEABLE_COLUMN" is raised by server.

Commits: 7b3bc30 eb1b480 5c0cec6

@firebird-automations
Copy link
Collaborator Author

Modified by: Raul Chirea (raul_chirea)

Component: Security [ 10071 ]

description: If a user who has permissions to select all columns in a table but to update only some columns, tries to prepare a statement like this:
"UPDATE THE_TABLE set WRITEABLE_COLUMN = 'something' where id = 11 RETURNING NON_WRITEABLE_COLUMN"
error -551 "no permission for update/write access to column NON_WRITEABLE_COLUMN" is raised by server.

=>

If a user who has permissions to select all columns in a table but to update only some columns, tries to prepare a statement like this:

"UPDATE THE_TABLE set WRITEABLE_COLUMN = 'something' where id = 11 RETURNING NON_WRITEABLE_COLUMN"

error -551 "no permission for update/write access to column NON_WRITEABLE_COLUMN" is raised by server.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 2.5.1 [ 10333 ]

Version: 2.1.4 [ 10361 ]

Version: 2.5.0 [ 10221 ]

Version: 3.0 Initial [ 10301 ]

Version: 2.1.2 [ 10270 ]

Version: 2.1.1 [ 10223 ]

Version: 2.1.0 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.5.3 [ 10461 ]

Fix Version: 2.1.6 [ 10460 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Added full SQL script 3360.sql to reproduce mentioned issue

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Attachment: 3360.sql [ 12293 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA511 [ QA511 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Test created.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment