That is on my todo list to figure out when I do the revoke privilege implementation. But I am thinking that when a revoke privilege is processed, before dropping the dependent objects, a check will be made to see if some other privilege can replace the privilege being revoked and if so, then make the objects depend on the newly found privilege. I have not spent enough time yet to figure out exactly how I would code this.
Mamta
On 7/10/06, Daniel John Debrunner <[EMAIL PROTECTED]> wrote:
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.
