Postgres Pro
Downloads
Home   >   mailing lists

pgADMIN III access to table joins denied - Mailing list pgsql-novice

From Della-Croce, Gregory
Subject pgADMIN III access to table joins denied
Date
Msg-id F1CFB1E7A51CD846898BB039F441E04F0960B39428@elijah
Whole thread Raw
List pgsql-novice
Tree view

I am connecting to a 8.4 postgres database using a new username  USERRW.   I open the database fine with pgAdmin III and open a SQL editor.  I can SELECT any table in the db.  But as soon as I try to join two tables I get an error :

ERROR:  permission denied for relation department_group

 

********** Error **********

 

ERROR: permission denied for relation department_group

SQL state: 42501

I know that a GRANT ALL <TableName> TO USERRW   was done and committed.   What are we missing?

 

 

Greg Della-Croce

 

pgsql-novice by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: Joining time fields?
Next
From: Tom Lane
Date:
Subject: Re: Is there an answer to the Ultimate Question for PostgreSQL?