[Zope] Postgres permissions with psycopyg

[tillea@rki.de]

Hello,

I=B4m using Zope 2.3.2, PostgreSQL 7.1.2 and psycopg 0.99.2.
Opening a database connection works well.  I used the connection string:

    dbname=3Dweb

Unfortunately if I want to test the connection using

    select * from testtable ;

I get

Error Type: ProgrammingError
Error Value: ERROR: mitarbeiter: Permission denied. select * from testtable=
 ;


Looking at /var/log/postgres.log I see the following entries:

2001-06-19 14:05:24 [22300]  DEBUG:  connection: host=3D[local] user=3Dwww-=
data database=3Dweb
2001-06-19 14:05:43 [22300]  ERROR:  testtable: Permission denied.

where www-data is the user which runs apache and zope on a Debian system.
I made sure in psql:

   web=3D# grant all on testtable to "web-data" ;
   CHANGE

but this does not help here.  (I see no possibilty to test access of
user www-data directly in psql because it is not a real user which has
no login on the system - or is there any way to do that?).

Any hints how to fix that?

Kind regards

         Andreas.