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 > ---------------------------(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
