Mamta Satoor wrote: [example snipped] > revoke select on t1 from user2 > -- at this point, only view user2.v1 should get dropped because it depends > on the SELECTPRIV on t1. But dependency manager has no way to know that > user2.v1 needs only SELECTPRIV and hence only object affected by this > revoke
How are you going to handle the case that before the REVOKE above was issued, this GRANT was executed? grant select on t1 to PUBLIC Would that mean that the view must not be dropped? Dan.
