Re: Solution for RI permission problem

Stephan Szabo writes:

> With that, I do have a general question though. Are referential actions
> supposed to be limited by the permissions of the user executing the query?
> So, if you for example have write access on the pk table, but not to the
> fk table, and there is a on cascade delete relationship, should that user
> not be able to delete from the pk table?

Then you could delete records that are not in relation to the foreign keys
in your table.  So I suppose not.  Of course there does seem to be a very
limited range of usefulness of such a setup, but we shouldn't extrapolate
something potentially more useful from that.


-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/