Revoke priv from role fails when view is present

[Paul Low]

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>

[Roberta Marton (roberta-marton)]

Check for retaining the SELECT privilege on a revoke was moved to after all privilege descriptors were analyzed.