Which GRANTS are needed on a Sequnce?

Поиск
Список
Период
Сортировка
От Dani Oderbolz
Тема Which GRANTS are needed on a Sequnce?
Дата
Msg-id 3EFC5825.8040904@ecologic.de
обсуждение исходный текст
Ответы Re: Which GRANTS are needed on a Sequnce?
Re: Which GRANTS are needed on a Sequnce?
Список pgsql-novice
Hi all,
I just created a Sequence S for User A.
User B has the USAGE Privilage in Schema A.
I granted SELECT On S TO B.
But this does not seem to be enough to use the Sequcence,
postgres claims:
 [1] ERROR:  S.nextval: you don't have permissions to set sequence S
So I granted ALL ON S TO B
which works fine.
What are the minimal grants neeeded? (And where is it documented,
the reference of 7.3.3 sais nothing about Sequences)

Cheers,
Dani





В списке pgsql-novice по дате отправления:

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: Re: Probably a stupid question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: missing postmaster.conf