[jira] [Created] (TRAFODION-1273) LP Bug: 1465356 - Revoke privilege from role returns dependent object error

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

Alice Chen created TRAFODION-1273:
-------------------------------------

             Summary: LP Bug: 1465356 - Revoke privilege from role returns dependent object error
                 Key: TRAFODION-1273
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1273
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Roberta Marton
            Priority: Critical
             Fix For: 2.0-incubating


Dependent object error is returned while performing a revoke privilege on a view from role.
"*** ERROR[1025] Request failed.  Dependent object TRAFODION.SCHEMA1.A09VIEW1 exists." is returned when revoking a privilege from a role right after the privilege has been granted.
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.col1,a09tab2.col2 from a09tab1,a09tab2 where a09tab1.col3=a09tab2.col2;

--- 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.SCHEMA1.A09VIEW1 exists.



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