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.