db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: Issue with using dependency manager for table level permission tracking
Date Tue, 11 Jul 2006 00:32:03 GMT
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.


Mime
View raw message