> First: CREATE ROLE and CREATE DATABASE;
> After: CREATE TABLEs; > Last: GRANT SELECT,INSERT,UPDATE and DELETE. OK, I dropped the database. Since I have the user already created, I recreated the database. Then I created all of the tables. Then I did this: postgres=# GRANT SELECT ON ALL TABLES IN SCHEMA public TO veure_user; GRANT postgres=# GRANT INSERT ON ALL TABLES IN SCHEMA public TO veure_user; GRANT postgres=# GRANT UPDATE ON ALL TABLES IN SCHEMA public TO veure_user; GRANT postgres=# GRANT DELETE ON ALL TABLES IN SCHEMA public TO veure_user; GRANT Same error: permission denied for relation "users". And when I do \dt: Schema | Name | Type | Owner --------+-------------------+-------+------------ public | users | table | veure_user So I'm still missing something here :) I'm sure my password is correct because this works (password in .pgpass, though the fact that I'm connecting suggests that my password is fine): $ psql -U veure_user -d veure psql (9.1.11) Type "help" for help. 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:49, JotaComm <jota.c...@gmail.com> wrote: Hello, > > > > >2014-01-30 Ovid <curtis_ovid_...@yahoo.com> > >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_...@yahoo.com> 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 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? > > >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 > >-- >JotaComm >http://jotacomm.wordpress.com > >
