On Mon, May 19, 2003 at 01:59:52PM +0200, Zeugswetter Andreas SB SD wrote:
> What you need is one view that is a union all select selecting all your
> partial tables, all applications only accesses this one view. You need 1
> insert 2 update 1 delete rule for each table plus 3 remainder rules (=4*N
> + 3 rules) (the select rule is already done by create view), plus one
> check constraint for each partial table.
WOW! You *are* good. Care to reveal the trick? I can see the insert and
delete rules but what are you doing for the updates?
> You can restrict access to the partial tables with normal grant/revoke's.
> The appls only need grants on the view (which is updateable with above
> rules).
Good point.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
> - Samuel P. Huntington