Dave Coventry 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? GRANT USAGE on SEQUENCE currenttest_id_seq TO drupaluser; I think that it is a good idea to have different users for table creation and usage (if possible). But I would not use a superuser account. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
