Privilege lost in replacement view after create or replace view command
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Released
|
Medium
|
Cliff Gray |
Bug Description
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/
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.
SQL>
Changed in trafodion: | |
milestone: | none → r1.1 |
Changed in trafodion: | |
importance: | Low → Medium |
assignee: | Anoop Sharma (anoop-sharma) → Roberta Marton (roberta-marton) |
Changed in trafodion: | |
assignee: | Roberta Marton (roberta-marton) → Cliff Gray (cliff-gray) |
Changed in trafodion: | |
status: | New → In Progress |
Fix delivered in 1082/