Re: Insufficient privileges. - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Insufficient privileges.
Date
Msg-id D960CB61B694CF459DCFB4B0128514C206A3E37F@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Insufficient privileges.  (Dave Coventry <dgcoventry@gmail.com>)
List pgsql-general
Dave Coventry wrote:
> I am getting the following error message in my Drupal install.
>
> PDOException: SQLSTATE[42501]: Insufficient privilege: 7 ERROR:
> permission denied for sequence currenttest_id_seq: INSERT INTO
> currentTest (score) VALUES (:db_insert_placeholder_0);
>
> This is a table that I created using the postgres super user.
>
> I have tried to grant the drupal user (drupaluser) privileges
> to the table with:
>
> GRANT ALL ON currentTest to drupaluser;
>
> but this fails to resolve the issue.
>
> Can anyone suggest a way forward?

GRANT USAGE on SEQUENCE currenttest_id_seq TO drupaluser;

I think that it is a good idea to have different users for
table creation and usage (if possible).
But I would not use a superuser account.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Darren Duncan
Date:
Subject: Re: [HACKERS] Creating temp tables inside read only transactions
Next
From: David Hartveld
Date:
Subject: Re: Streaming replication on 9.1-beta2 after pg_restore is very slow