Grant question

From: Barbara Lindsey <blindsey(at)cog(dot)ufl(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Grant question
Date: 2004-01-29 14:52:56
Message-ID: 40191E48.60107@cog.ufl.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2004-01-29 14:54:49 Re: Grant question
Previous Message W. van den Akker 2004-01-29 14:25:35 PQtrace doesn't work