[jira] [Created] (TRAFODION-801) LP Bug: 1398546 - Revoke priv from role fails when view is present

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

Alice Chen created TRAFODION-801:
------------------------------------

             Summary: LP Bug: 1398546 - Revoke priv from role fails when view is present
                 Key: TRAFODION-801
                 URL: https://issues.apache.org/jira/browse/TRAFODION-801
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Roberta Marton
            Priority: Critical
             Fix For: 1.1 (pre-incubation)


The user should not be required to drop the view in order to revoke the privilege from the roles.

SQL>create role role11;

--- SQL operation complete.

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

--- SQL operation complete.

SQL>create view view11 as select * from tab11;

--- SQL operation complete.

SQL>grant all on tab11 to role11;

--- SQL operation complete.

SQL>revoke all on tab11 from role11;

*** ERROR[1025] Request failed.  Dependent object TRAFODION.SEABASE.VIEW11 exists.

SQL>revoke all on tab11 from role11 cascade;

*** ERROR[1025] Request failed.  Dependent object TRAFODION.SEABASE.VIEW11 exists.

SQL>



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