Issue Details (XML | Word | Printable)

Key: CORE-3360
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Raul Chirea
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause

Created: 24/Feb/11 03:39 AM   Updated: 25/Sep/15 12:25 PM
Component/s: Engine, Security
Affects Version/s: 2.1.0, 2.1.1, 2.1.2, 2.1.3, 3.0 Initial, 2.5.0, 2.1.4, 2.5.1
Fix Version/s: 3.0 Alpha 1, 2.1.6, 2.5.3

File Attachments: 1. File 3360.sql (0.4 kB)

Environment:
firebird-2.1.3.18185.0-6.fc12.x86_64
ISQL Version: LI-V2.1.3.18185 Firebird 2.1
Server version:
Firebird/linux AMD64 (access method), version "LI-V2.1.3.18185 Firebird 2.1"
Firebird/linux AMD64 (remote server), version "LI-V2.1.3.18185 Firebird 2.1/tcp (terminus)/P11"
Firebird/linux AMD64 (remote interface), version "LI-V2.1.3.18185 Firebird 2.1/tcp (terminus)/P11"
on disk structure version 11.1
Issue Links:
Relate
 

QA Status: Done successfully


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 11/Mar/13 03:48 PM - edited
Added full SQL script 3360.sql to reproduce mentioned issue

Pavel Cisar added a comment - 25/Sep/15 12:25 PM
Test created.