On Mon, 5 May 2008 12:48:47 +0200, Bonnetot Jean-Daniel <[EMAIL PROTECTED]> wrote:
> Fri, 02 May 2008 02:34:43 +0200, Colin Brace: >> OK. did that. Alas, another SQL error: >> >> [05/02/2008 01:47:24] 11421: ERROR: permission denied for relation >> dspam_virtual_uids >> : SELECT uid FROM dspam_virtual_uids WHERE username = 'colin' > Check your dspam SQL user and his permissions. Is he authorized to > read/write dspam_virtual_uids table? Since I am very new to Postgres, I am using phpPgAdmin to deal with the database. I see the following privileges are indicated for the dspam db: Type User/Group CREATE TEMPORARY CONNECT Grantor public No Yes Yes dspam user dspam Yes Yes Yes dspam I've run this command: su - pgsql -c 'cat /usr/local/share/examples/dspam/pgsql/pgsql_objects.sql | psql -U pgsql dspam' so I assume the structure is set up correctly, but I don't seen anywhere to configure permissions for the "dspam_virtual_uids" table; in fact, I don't see this table anywhere. Is this something I need to do on the command line? Thanks, and excuses for my ignorance of postgres. -- Colin Brace Amsterdam http://lim.nl !DSPAM:1011,48223359122631102810327!
