db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject Re: Issue with using dependency manager for table level permission tracking
Date Tue, 11 Jul 2006 00:51:29 GMT
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.


On 7/10/06, Daniel John Debrunner <djd@apache.org> 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.

View raw message