Re: Grant question - More - Mailing list pgsql-general

From Barbara Lindsey
Subject Re: Grant question - More
Date
Msg-id 40195E7E.8040300@cog.ufl.edu
Whole thread Raw
In response to Grant question  (Barbara Lindsey <blindsey@cog.ufl.edu>)
Responses Re: Grant question - More  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-general
What permission does a user need to have to query the pg_ tables
(pg_attribute, pg_class, etc) ?  Do they require special permissions?


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



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


pgsql-general by date:

Previous
From: Martin Marques
Date:
Subject: Planner configuration
Next
From: Brendan Jurd
Date:
Subject: Re: Update Default