Re: permission denied for schema

[jef peeraer <jef(dot)peeraer(at)telenet(dot)be>]

Tom Lane schreef:
> jef peeraer <jef(dot)peeraer(at)telenet(dot)be> writes:
> > i get this when i try to insert a record into a table. all permissions / 
> > privileges seems ok, but probably i missed something. i am running a 
> > 8.1.3 on linux.
>
> > registratie=> INSERT INTO clienten 
> > (anoniem,geslacht,leeftijd,origine,team_id,hulpverlener_id) VALUES 
> > ('true','45','58','864','30','221');
> > ERROR:  permission denied for schema deterp
> > CONTEXT:  SQL statement "SELECT 1 FROM ONLY "deterp"."teams" x WHERE 
> > "id" = $1 FOR SHARE OF x"
>
> 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}
(1 row)


> 			regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings