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 -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
