I think you should provide an explicit grant (all) on the sequence as
well. The Sequence is an object that is distinct from the table that uses
it.
John Sidney-Woollett
Barbara Lindsey said:
> What kind of grant do you need to give a user so that they can have
> permission to do a "SELECT nextval(ID)" on a sequence?
> I granted the user SELECT,UPDATE,INSERT,DELETE on all the tables,
> including the one that has the sequence, but the sequence query is
> failing on permissions.
>
> --
> Barbara E. Lindsey,
> COG RDC
> Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162
>
> ----
> CONFIDENTIALITY NOTICE: The information contained in this electronic
> message is legally privileged and confidential and intended only for the
> use of the individual(s) or entity(ies) named above. If the reader of
> this message is not the intended recipient, you are hereby notified that
> any dissemination, distribution, or copying of this email or any of it's
> components is strictly prohibited. If you have received this email in
> error, please contact the sender.
> ----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>