Re: SET LOCAL ROLE inside SECURITY INVOKER (LANGUAGE plpgsql) function

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: SET LOCAL ROLE inside SECURITY INVOKER (LANGUAGE plpgsql) function
Дата
Msg-id CAFCRh-8D+R=xufTFYN8SDDeEVwDNCb7kcspt9hsRW2T-QOMoKg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SET LOCAL ROLE inside SECURITY INVOKER (LANGUAGE plpgsql) function  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: SET LOCAL ROLE inside SECURITY INVOKER (LANGUAGE plpgsql) function
Список pgsql-general
On Wed, Jul 30, 2025 at 9:42 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> My suspicion is that there is a missing piece in your chain of roles.

But my point Adrian is that, in my case, has_table_privilege() returns
true (t) yet the delete fails. Contrary to your example above. I can
easily accept that the problem lies on my side, but how can
has_table_privilege() "lie" like this?



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