Re: User privileges on sequences

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: User privileges on sequences
Дата
Msg-id Pine.LNX.4.30.0110172018590.628-100000@peter.localdomain
обсуждение исходный текст
Ответ на User privileges on sequences  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
Список 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 по дате отправления:

Предыдущее
От: Jon Lapham
Дата:
Сообщение: yet another db corruption issue (more info)
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: To Postgres Devs : Wouldn't changing the select limit