Re: permission denied for relation

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(at)iol(dot)ie