Re: noob trying to use PG with Zope

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Programmer" <programmer(at)paradigm-corp(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: noob trying to use PG with Zope
Date: 2007-05-11 02:19:46
Message-ID: 9875.1178849986@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Programmer" <programmer(at)paradigm-corp(dot)com> writes:
> Once it appeared to be working I created a table and added a few rows to
> it in psql. Then for the role being used by my Zope connection I did a
> GRANT ALL for the new table.
>
> Problem is I get a permission denied error anytime I try to run a SELECT
> on the table.

The problem is doubtless hidden in the details you didn't mention :-(.
What exactly was the GRANT command you issued? What exactly is the
error message you get?

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Nicholas Bott 2007-05-11 23:45:29 Executing dynamic queries without functions / procedures
Previous Message Programmer 2007-05-10 19:20:10 noob trying to use PG with Zope