Yay! It works. Thank you.
Bruno Wolff III wrote:
On Thu, Jan 29, 2004 at 09:52:56 -0500, Barbara Lindsey <[EMAIL PROTECTED]> wrote:
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.
Sequences have permissions separate from tables. I believe you need update access to call nextval or setval on a sequence. This should be described in the documention on the GRANT command.
-- 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
