Privilege lost in replacement view after create or replace view command

[Paul Low]

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>

[Cliff Gray (cliff-gray)]

Fix delivered in 1082/

[Paul Low (paul-low-x)]

verified on 20150219 build