||[Jun. 6th, 2007|01:32 pm]
I have a user. let's call him "websitedev". I also have a database called "events" which was created by user "postgres". I have a php application that this user "websitedev" is able to connect to the database, the problem is it doesn't have permissions to access the tables.
grant all privileges on database events to websitedev with grant option;
But when I try to connect via the website application I am still getting.
Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: permission denied for relation tablename in path/to/file.php on line 59