UPDATE requires SELECT access

Bug #1457493 reported by Cliff Gray on 2015-05-21
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
New
High
Suresh Subbiah

Bug Description

Granting the UPDATE privilege to a user should be sufficient for them to update a table, but the SELECT privilege is also required.

Test case:

As DB__ROOT
INITIALIZE AUTHORIZATION; -- If not already initialized
CREATE TABLE T1 (A INT NOT NULL);
GRANT UPDATE ON T1 TO SQL_USER1;
INSERT INTO T1 VALUES(0);

As SQL_USER1
UPDATE T1 SET A = 1;

*** ERROR[4481] The user does not have SELECT privilege on table or view TRAFODION.SCH.T1.

The error is reported in RelRoot::checkPrivileges(), but the problem (from privilege viewpoint) is that the stoi has select access set to true.

Cliff Gray (cliff-gray) on 2015-06-02
Changed in trafodion:
importance: Undecided → High
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers