Re: noob trying to use PG with Zope - Mailing list pgsql-novice

From Tom Lane
Subject Re: noob trying to use PG with Zope
Date
Msg-id 9875.1178849986@sss.pgh.pa.us
Whole thread Raw
In response to noob trying to use PG with Zope  ("Programmer" <programmer@paradigm-corp.com>)
List pgsql-novice
"Programmer" <programmer@paradigm-corp.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

pgsql-novice by date:

Previous
From: "Programmer"
Date:
Subject: noob trying to use PG with Zope
Next
From: Nicholas Bott
Date:
Subject: Executing dynamic queries without functions / procedures