Hi all,
Struggling to figure out what I'm doing wrong with postgresql 9.1.11.
I've created a user and database like this:
CREATE USER some_user WITH ENCRYPTED PASSWORD '...';
CREATE DATABASE mydatabase ENCODING 'UTF8' OWNER some_user TEMPLATE template0;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO some_user;
I then have a shell script which rebuilds my database, but when I connect with my software, I get this:
DBD::Pg::st execute failed: ERROR: permission denied for relation users [for Statement ...
If it matters, my pg_hba.conf has this:
# Database administrative login by Unix domain socket
local all postgres peer
local all veure_user trust
And uname:
$ uname -a
Linux foo.example.com 3.2.0-4-amd64 #1 SMP Debian 3.2.39-2 x86_64 GNU/Linux
I've gotten this successfully running on my laptop and home machine (both Macs) using an identical code base, but I don't know what I'm missing on the Debian server.
In short, I have a user that requires full SELECT, INSERT, UPDATE, and DELETE privileges on the "mydatabase" database.
Can someone point me in the right direction?
Cheers,
Ovid
--
IT consulting, training, international recruiting
http://www.allaroundtheworld.fr/.
Buy my book! - http://bit.ly/beginning_perl
Live and work overseas - http://www.overseas-exile.com/