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

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-801?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Wayne Birdsall closed TRAFODION-801.
------------------------------------------
    Resolution: Fixed

> 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)