Re: User privileges on sequences - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: User privileges on sequences
Date
Msg-id Pine.LNX.4.30.0110172018590.628-100000@peter.localdomain
Whole thread Raw
In response to User privileges on sequences  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
List pgsql-general
Mihai Gheorghiu writes:

> Therefore, I have to give users permissions to sequences, just to the
> extent that they could add records. What is the minimum set of
> privileges for this?

You need UPDATE privileges to be able to execute nextval() and currval().
I assume this would include setval() as well, though I don't see it in the
docs offhand.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Jon Lapham
Date:
Subject: yet another db corruption issue (more info)
Next
From: Peter Eisentraut
Date:
Subject: Re: To Postgres Devs : Wouldn't changing the select limit