Re: permission denied for schema

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> jef peeraer <jef(dot)peeraer(at)telenet(dot)be> writes:
>> Tom Lane schreef:
>>> That's a foreign-key check, which is supposed to be done as the owner of
>>> the table. You did not show us who owns table clienten, but I think
>>> that role must be missing the intended(?) membership in deterp_group.
>
>> registratie=# \z deterp.clienten;
>> Access privileges for database "registratie"
>> Schema | Name | Type | Access privileges
>> --------+----------+-------+------------------------------------------
>> deterp | clienten | table | {jpe=arwdxt/jpe,deterp_group=arwdxt/jpe}
>
> Hmm. This doesn't actually say so, but I think that jpe must be the
> owner of clienten, and he's also the owner of the schema. Which makes
> the failure really darn odd.
>
> I tried to reproduce the situation on 8.1.9 and couldn't see any
> problem. I do not see anything in the 8.1 CVS history that looks
> related, but it's slightly possible this is a bug that's fixed between
> 8.1.3 and 8.1.9 (and even if that is not the case, you really really
> ought to update anyway).

Just for the record, I've seen the same problem in my database (a
superuser trying to INSERT leads to the same security exception), not
sure which release but the version was 8.1. Haven't seen the problem
for some time now, currently running 8.1.8.

Regards,
Manuel.