Ivan Sergio Borgonovo schrieb:
On Tue, 10 Mar 2009 14:31:56 +0100
Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
