Postgres Pro
Downloads
Home   >   mailing lists

Insufficient privileges. - Mailing list pgsql-general

From Dave Coventry
Subject Insufficient privileges.
Date
Msg-id CACbSWtZaLn-C_1vBWyFoNgzvC+twbrHbRqqDxgndcz2mVs9+ug@mail.gmail.com
Whole thread Raw
Responses Re: Insufficient privileges.  (Rick Genter <rick.genter@gmail.com>)
Re: Insufficient privileges.  (John R Pierce <pierce@hogranch.com>)
Re: Insufficient privileges.  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Oracle to Postgres migration open source tool
Next
From: Rick Genter
Date:
Subject: Re: Insufficient privileges.