[jira] [Created] (TRAFODION-1100) LP Bug: 1437470 - Creator of view in private schema unable to select from view

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

Alice Chen created TRAFODION-1100:
-------------------------------------

             Summary: LP Bug: 1437470 - Creator of view in private schema unable to select from view
                 Key: TRAFODION-1100
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1100
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Cliff Gray
            Priority: Critical
             Fix For: 2.0-incubating


Security is enabled on the instance.
Table and view are created by user on a private schema where he is granted CREATE privilege.
User is able to select from table, but unable to select from the view that he created.
According to documentation, the creator of the object is granted full DML privileges on the object they create.

SQL>select * from myview2;

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


See log of sequence below:


Connected to Trafodion 

SQL>create schema sch001;

--- SQL operation complete.

SQL>grant COMPONENT privilege "CREATE" on sql_operations to username1;

--- SQL operation complete.

SQL>connect username1/password1
Connected to Trafodion 

SQL>set schema sch001;

--- SQL operation complete.

SQL>create table mytable (a int, b int);

--- SQL operation complete.

SQL>insert into mytable values (1,1);

--- 1 row(s) inserted.

SQL>create view myview2 as select * from mytable;

--- SQL operation complete.

SQL>select * from mytable;

A           B          
----------- -----------
          1           1

--- 1 row(s) selected.

SQL>select * from myview2;

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



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