update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause [CORE3360] #3726
Labels
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.1.4
affect-version: 2.5.0
affect-version: 2.5.1
affect-version: 3.0 Initial
component: engine
component: security
fix-version: 2.1.6
fix-version: 2.5.3
fix-version: 3.0 Alpha 1
priority: major
qa: done successfully
type: bug
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
The text was updated successfully, but these errors were encountered: