| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Solution for RI permission problem |
| Date: | 2000-10-01 21:05:14 |
| Message-ID: | Pine.LNX.4.21.0010012300370.7107-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joost Kraaijeveld | 2000-10-01 21:10:38 | RE: What do I need to be able to compile the source in Win32 |
| Previous Message | Peter Eisentraut | 2000-10-01 20:49:51 | Re: grant/revoke bug with delete/update |