pgADMIN III access to table joins denied

From: "Della-Croce, Gregory" <Greg_Della-Croce(at)wycliffe(dot)org>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: pgADMIN III access to table joins denied
Date: 2012-07-26 14:47:17
Message-ID: F1CFB1E7A51CD846898BB039F441E04F0960B39428@elijah
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2012-07-26 14:49:52 Re: Is there an answer to the Ultimate Question for PostgreSQL?
Previous Message Oliveiros d'Azevedo Cristina 2012-07-26 14:33:07 Re: Joining time fields?