Antonis Kanavouras ([EMAIL PROTECTED]) 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
