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: 17A09E9509BB354E95C2FEE5102B0F5F0131562A@audiinsx0036.audi.vwg (view raw or flat)
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;
> 
> CREATE 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)

Lars

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-2014 The PostgreSQL Global Development Group