Обсуждение: noob trying to use PG with Zope
HI,
I am trying to learn PostgreSQL for use with Zope. I have Zope 2.9.6, PostgreSQL 8.2 on XP with the Psycopg2 adapter. I had no real problems getting it setup and it is working ok. When I go to the database connection in Zope and test it with SELECT version() I get the correct output.
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. I've been going through the documentation for hours now with no joy. I suspect the problem is my lack of experience with PostgreSQL. Can anybody offer some advice on this problem?
Thanks!
M. A. Ruberto (Programmer)
Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.
"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