Skip site navigation (1) Skip section navigation (2)

Re: Relation does not exist problem

From: "Oeschey, Lars (I/EK-142, extern)" <extern(dot)Lars(dot)Oeschey(at)AUDI(dot)DE>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Relation does not exist problem
Date: 2007-09-18 13:23:14
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
> you dont have to grant the schema usage to the user and the 
> group. if you 
> grant it to the group, its granted to the groupmembers 
> implicit. if you 
> select the schema in pgadmin you should see something like
> -- Schema: "entry"
> -- DROP SCHEMA entry;
>   AUTHORIZATION postgres;
> GRANT ALL ON SCHEMA entry TO postgres;
> GRANT USAGE ON SCHEMA entry TO GROUP contact_user_group;

I found the problem. Starting with postgreSQL 8, the rights for users
have to be inherited from the group. So that a user inherits the rights
from the group where it is member, it has to have the flag INHERIT set
(standard when generating a user is NOINHERIT)


In response to

pgsql-novice by date

Next:From: Rodrigo De LeónDate: 2007-09-18 16:31:21
Subject: Re: ON INSERT => execute AWK/SH/EXE?
Previous:From: Robert WimmerDate: 2007-09-18 13:06:41
Subject: Re: Relation does not exist problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group