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@xxxxxxxxx> wrote: > > > On Thu, Jul 7, 2011 at 10:03 AM, Dave Coventry <dgcoventry@xxxxxxxxx> 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@xxxxxxxxx > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
