UPDATE requires SELECT access

Bug #1457493 reported by Cliff Gray
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.

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.