From: | Rick Genter <rick(dot)genter(at)gmail(dot)com> |
---|---|
To: | rick(dot)genter(at)gmail(dot)com |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Insufficient privileges. |
Date: | 2011-07-07 17:05:37 |
Message-ID: | CADie1rwLNTWVhtqMKKP3VDjaTu9o0Vs00V_DBgE7cq1NeCD4Ug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jul 7, 2011 at 10:03 AM, Dave Coventry <dgcoventry(at)gmail(dot)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(dot)genter(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Coventry | 2011-07-07 17:26:40 | Re: Insufficient privileges. |
Previous Message | Dave Coventry | 2011-07-07 17:03:23 | Insufficient privileges. |