Re: bug?: permission denied for schema on "on delete set null"

Ivan Sergio Borgonovo schrieb:
> On Tue, 10 Mar 2009 14:31:56 +0100
> Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> wrote:
>
>> which rights does the actual user have for the schema user_test?
>>
>> > Query failed: ERROR: permission denied for schema user_test
>> > CONTEXT:
>>
>> I think the user does not have the rights for the schema ...
>
> I just run
> http://pgedit.com/tip/postgresql/access_control_functions
> on public and user_test schema +
> grant all on schema user_test to user_test;
>
> It was related to something similar to this:
> http://archives.postgresql.org//pgsql-general/2007-06/msg01365.php
>
> I still have to sort it out since I did some random changes to
> ownership of schema and tables.
>
> It seems that the schemas have to be owned by the "group" and not by
> the single users.
>
> To sum it up:
>
> a role as a group owning everything
> several roles as "users" member of the previous role
> everything owned by the "group"
> permissions assigned to the single users

In general you will put a user into a group role. And if the group role
does not have the permissions for the schema you will run into this
issue. So give the permissions to the group role and it will work ...

Check this out:

http://archives.postgresql.org//pgsql-admin/2009-02/msg00268.php

up to

http://archives.postgresql.org//pgsql-admin/2009-02/msg00274.php

maybe you follow that discussion for some minutes ...

Cheers

Andy