Skip site navigation (1) Skip section navigation (2)

Bug #507: Granting insert on a table does not grant update to the ralated sequence

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #507: Granting insert on a table does not grant update to the ralated sequence
Date: 2001-11-03 15:07:10
Message-ID: 200111031507.fA3F7A593036@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Antonis Kanavouras (ankan(at)hungry(dot)gr) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Granting insert on a table does not grant update to the ralated sequence

Long Description
I recently upgrated to PostgreSQL 7.1.3 from 7.0.something (I don't remember exactly)

I dumped my databases, intstalled PostgreSQL v 7.1.3 and created my databases from the text-dump. The users privileges were allready set-up correctly on the tables. But everytime a user -other than the db owner- tried to insert a row in a table in witch he had append permission he got an error message. The reason: he had no update privilegde to the sometable_id_seq. ('id' in my case is an autoincrementing integer just to identify the row). I solved it so:


somedb# GRANT UPDATE ON sometable_id_seq TO someuser ;

but I think that this must be granted automaticaly when I grant insert to someuser on sometable.

Friendly
Antonis Kanavouras

Sample Code


No file was uploaded with this report


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-11-04 03:57:17
Subject: Bug #508: update not atomic
Previous:From: Aaron HillegassDate: 2001-11-03 04:53:57
Subject: psql needs an option to set hostaddr instead of host

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group