From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Dave Coventry *EXTERN*" <dgcoventry(at)gmail(dot)com>, "pgsql-general General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Insufficient privileges. |
Date: | 2011-07-08 07:14:29 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C206A3E37F@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | mike beeper | 2011-07-08 07:51:37 | Re: [HACKERS] Creating temp tables inside read only transactions |
Previous Message | Gavin Flower | 2011-07-08 06:38:59 | Re: [HACKERS] Creating temp tables inside read only transactions |