Re: Possible bug with permissions. (Table A has select , insert, update rights but has a reference to a second table that only has select rights)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: wleibe(at)teamdev(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Possible bug with permissions. (Table A has select , insert, update rights but has a reference to a second table that only has select rights)
Date: 2000-10-10 03:56:37
Message-ID: 17756.971150197@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Wendel Leibe" <wleibe(at)teamdev(dot)com> writes:
> Here is the problem. If I try to insert a contact record as, "confUser."
> "psql" and my DBI driver for perl fails with a permission error on objects.
> If I give confUser permissions to write to the objects table the statement
> will execute.

Currently, REFERENCES foreign-key constraints are implemented with a
trigger that does SELECT FOR UPDATE on the referenced table. SELECT
FOR UPDATE requires write privileges on the target table, so you get
this behavior. It's generally agreed that that's not the desired
behavior, but I'm not sure what the state of play is on fixing it.
You'll find plenty of info if you check the mail list archives.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-10-10 04:02:51 Re: pg_dump 7.0.2 fails on linuxppc
Previous Message Tom Lane 2000-10-10 03:44:59 Re: TCL, but not TK