Postgres Pro
Downloads
Home   >   mailing lists

Re: Insufficient privileges. - Mailing list pgsql-general

From Rick Genter
Subject Re: Insufficient privileges.
Date
Msg-id CADie1rwLNTWVhtqMKKP3VDjaTu9o0Vs00V_DBgE7cq1NeCD4Ug@mail.gmail.com
Whole thread Raw
In response to Insufficient privileges.  (Dave Coventry <dgcoventry@gmail.com>)
Responses Re: Insufficient privileges.
List pgsql-general
Tree view


On Thu, Jul 7, 2011 at 10:03 AM, Dave Coventry <dgcoventry@gmail.com> 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?

From the message I'd say that the drupal user doesn't have access to the sequence, which is a separate object from the table.

--
Rick Genter
rick.genter@gmail.com

pgsql-general by date:

Previous
From: Dave Coventry
Date:
Subject: Insufficient privileges.
Next
From: Dave Coventry
Date:
Subject: Re: Insufficient privileges.