Postgres Pro
Downloads
Home   >   mailing lists

Re: permission denied for relation - Mailing list pgsql-general

From Ovid
Subject Re: permission denied for relation
Date
Msg-id 1391091236.91384.YahooMailNeo@web125102.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: permission denied for relation  (JotaComm <jota.comm@gmail.com>)
Responses Re: permission denied for relation  (Raymond O'Donnell <rod@iol.ie>)
Re: permission denied for relation  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view
> 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.comm@gmail.com> wrote:
Hello,


2014-01-30 Ovid <curtis_ovid_poe@yahoo.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@yahoo.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


pgsql-general by date:

Previous
From: JotaComm
Date:
Subject: Re: permission denied for relation
Next
From: Raymond O'Donnell
Date:
Subject: Re: permission denied for relation