From: | Ovid <curtis_ovid_poe(at)yahoo(dot)com> |
---|---|
To: | JotaComm <jota(dot)comm(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: permission denied for relation |
Date: | 2014-01-30 14:13:56 |
Message-ID: | 1391091236.91384.YahooMailNeo@web125102.mail.ne1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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(dot)comm(at)gmail(dot)com> wrote:
Hello,
>
>
>
>
>2014-01-30 Ovid <curtis_ovid_poe(at)yahoo(dot)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_poe(at)yahoo(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2014-01-30 14:21:30 | Re: permission denied for relation |
Previous Message | JotaComm | 2014-01-30 13:46:20 | Re: permission denied for relation |