select current_user;
On Thu, Jan 30, 2014 at 3:53 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
On 01/30/2014 06:13 AM, Ovid wrote:I would tend to go with Raymond, are you sure about the user you are connecting as?
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 :)
It would be helpful to tail the Postgres log and see what the connection info is.Well if your pg_hba.conf is the same as before :
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.
local all veure_user trust
than a password is not being used. So connecting does not prove a valid password.
Cheers,
Ovid
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
