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?
Dave Coventry