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

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

--
Ivan Sergio Borgonovo
http://www.webthatworks.it