Revoke privilege from role returns dependent object error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Roberta Marton |
Bug Description
Dependent object error is returned while performing a revoke privilege on a view from role.
"*** ERROR[1025] Request failed. Dependent object TRAFODION.
See previously fixed bug #1398546. Seems to be similar issue.
See log below.
Build: daily build 20150613
SQL>create role role1;
--- SQL operation complete.
SQL>create schema schema1;
--- SQL operation complete.
SQL>set schema schema1;
--- SQL operation complete.
SQL>create table a09tab1(col1 int,col2 int,col3 int)no partition;
--- SQL operation complete.
SQL>create table a09tab2(col1 int,col2 int)no partition;
--- SQL operation complete.
SQL>create view a09view1(a,b) as select a09tab1.
--- SQL operation complete.
SQL>grant select on a09view1 to role1;
--- SQL operation complete.
SQL>revoke select on a09view1 from role1;
*** ERROR[1025] Request failed. Dependent object TRAFODION.
Changed in trafodion: | |
assignee: | Cliff Gray (cliff-gray) → Roberta Marton (roberta-marton) |
Changed in trafodion: | |
status: | New → In Progress |
There is a check in mainline revoke code to determine if the object type is a view and if the SELECT privilege is no longer applicable. If so, then the dependent error is returned. However, this code is incorrect and actually the correct code exists in the gatherViewPrivi leges method. The view check has been removed.