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-issue-importer opened this issue Feb 24, 2011 · 10 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 24, 2011

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-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 5, 2011

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 15, 2012

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-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 11, 2013

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-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 11, 2013

Commented by: @AlexPeshkoff

Added full SQL script 3360.sql to reproduce mentioned issue

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 11, 2013

Modified by: @AlexPeshkoff

Attachment: 3360.sql [ 12293 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 29, 2014

Modified by: @pcisar

Link: This issue is related to QA511 [ QA511 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 28, 2015

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 25, 2015

Commented by: @pcisar

Test created.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 25, 2015

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