[Zope] Postgres permissions with psycopyg

[Rene Pijlman]

[PostgreSQL]

> dbname=3Dweb

No user name?

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

With PostgreSQL, operating system users don't get access automatically. Y=
ou
must create a PostgreSQL user to connect as (defaults to OS user) and gra=
nt
privileges.

According to messages in the PostgreSQL list archive "www-data" is a spec=
ial
case, since PostgreSQL doesn't allow "-" in user names. I'm not sure if t=
his
still applies, since you mention a database user "web-data".

Just search the list on http://fts.postgresql.org/db/mw/ with "permission
denied". E.g.:
http://fts.postgresql.org/db/mw/msg.html?mid=3D53327
http://fts.postgresql.org/db/mw/msg.html?mid=3D30785

And this of course (URL of local mirror):
http://postgresql.demunnikservices.nl/users-lounge/docs/7.1/admin/user-ma=
nag
.html
http://postgresql.demunnikservices.nl/users-lounge/docs/7.1/admin/privile=
ges
.html

Regards,
Ren=E9 Pijlman