Hello,
2014-01-30 Ovid <curtis_ovid_poe@xxxxxxxxx>
And in the above, by "veure_user" in the pg_hba.conf, I obviously meant "some_user".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/
On Thursday, 30 January 2014, 14:31, Ovid <curtis_ovid_poe@xxxxxxxxx> wrote:
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 socketlocal all postgres peerlocal all veure_user trustI'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?
First: CREATE ROLE and CREATE DATABASE;
After: CREATE TABLEs;
Last: GRANT SELECT,INSERT,UPDATE and DELETE.
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/
Regards
