Re: Foreign keys and permissions oddity

On Sat, Aug 07, 2010 at 08:34:12AM +0100, Richard Huxton wrote:
> On 07/08/10 01:13, Joshua Tolley wrote:
>> Is there some justification for this behavior that I should know already? It
>> seemed awfully strange when some folkds here stumbled on it:
> [snip]
>> The key point seems to be that the owner of the referenced table has no
>> permissions on the table, although the referencing user does.
>
> Presumably the underlying trigger functions are executing as the owner
> of the table. This would make sense in the (more common) case that you
> want to reference a table you don't necessarily have full read access
> for (e.g. member-id vs the whole row including address/phone).

Yeah, that appears to be what's happening, based on the code. It's certainly
confusing to look at, and I'm not sure it couldn't be described a bug. I'll
continue to ponder that.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com