Re: Grant tables cascade to sequence?

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Grant tables cascade to sequence?
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B057D6C0A@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на Grant tables cascade to sequence?  (Rural Hunter <ruralhunter@gmail.com>)
Список pgsql-admin
Rural Hunter wrote:
> I encounter the same issue often: Granted update/insert to an user but
> forgot to grant it on the related sequence. It's hard to understand that
> an user has write access on table but not on necessary sequences. I
> think the grant on tables should cascade to related sequences. What do
> you think?

I think that would make sense.

To me this seems related to the case where table B has a
foreign key to table A with cascading delete or update.
If a user has privileges on A, he or she can change values in
B without having any privileges on B.

Yours,
Laurenz Albe


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

Предыдущее
От: Rural Hunter
Дата:
Сообщение: Grant tables cascade to sequence?
Следующее
От: Craig James
Дата:
Сообщение: Re: Grant tables cascade to sequence?