[jira] [Created] (TRAFODION-760) LP Bug: 1392107 - Privilege lost in replacement view after create or replace view command

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

Alice Chen created TRAFODION-760:
------------------------------------

             Summary: LP Bug: 1392107 - Privilege lost in replacement view after create or replace view command
                 Key: TRAFODION-760
                 URL: https://issues.apache.org/jira/browse/TRAFODION-760
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Cliff Gray
             Fix For: 1.1 (pre-incubation)


If a user had privileges on an old view before the 'create or replace view' command, the privilege is not carried over to the newly created view.  See log below.

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

--- SQL operation complete.

SQL>create table tab002 (x int, y int, z int);

--- SQL operation complete.

SQL>insert into tab001 values (1,2);

--- 1 row(s) inserted.

SQL>create view v001 as select * from tab001;

--- SQL operation complete.

SQL>grant select, insert on v001 to username1;

--- SQL operation complete.

SQL>connect username1/password1
Connected to Trafodion 

SQL>select * from v001;

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

--- 1 row(s) selected.

SQL>connect dbrootuser/dbrootpassword
Connected to Trafodion 

SQL>create or replace view v001 as select * from tab002;

--- SQL operation complete.

SQL>connect username1/password1
Connected to Trafodion 

SQL>select * from v001;

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

SQL>



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