On 30/01/2014 14:13, Ovid wrote: >> 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): Possibly a silly question, but are you sure that your software is connecting as user "veure_user"? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
