UPDATE requires SELECT access
Bug #1457493 reported by
Cliff Gray
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:
Changed in trafodion: | |
importance: | Undecided → High |
To post a comment you must log in.