Hi Rick,
Thanks for the response.
What is "the sequence"? and how do I grant the privileges needed to
insert data into the database?
Is it a postgres issue?
~ Dave
On 7 July 2011 19:05, Rick Genter <rick.genter@gmail.com> wrote:
>
>
> 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
>
>
