Re: Solution for RI permission problem - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Solution for RI permission problem
Date
Msg-id Pine.LNX.4.21.0010012300370.7107-100000@peter.localdomain
Whole thread Raw
In response to Re: Solution for RI permission problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Solution for RI permission problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
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/



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: On the subject of yacc...
Next
From: Joost Kraaijeveld
Date:
Subject: RE: What do I need to be able to compile the source in Win32