Re: permission denied for relation

[Ovid <curtis_ovid_poe@xxxxxxxxx>]

I turned on log_connections and that is indeed the problem. Looks like it's my software and not pg.

Thanks all!

 

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, 15:53, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:

On 01/30/2014 06:13 AM, 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 would tend to go with Raymond, are you sure about the user you are
connecting as?

It would be helpful to tail the Postgres log and see what the connection
info is.

>
> 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.


Well if your pg_hba.conf is the same as before :

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