[jira] [Created] (TRAFODION-1243) LP Bug: 1457493 - UPDATE requires SELECT access

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1243:
-------------------------------------

             Summary: LP Bug: 1457493 - UPDATE requires SELECT access
                 Key: TRAFODION-1243
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1243
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Cliff Gray
            Assignee: Suresh Subbiah
            Priority: Critical
             Fix For: 2.0-incubating


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)