Re: Security Definer functions no longer works in PG14+

Поиск
Список
Период
Сортировка
От Jobin Augustine
Тема Re: Security Definer functions no longer works in PG14+
Дата
Msg-id CAEpZXffZkdKAtEwmJL4hqm4nmNzhnqPHrSJ=KZC_bu2dHVHZMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Security Definer functions no longer works in PG14+  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: Security Definer functions no longer works in PG14+  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-bugs
Дерево обсуждения

Hi Amit,

Good to know that workaround helps your use case. But I am curious to know why you want to use Alter Subscription .. Refresh via function? The same restriction holds for Create/Drop Subscription as well but you don't seem to be using those via function.

Yes, the workaround really helps to continue the operations as it was.
let me explain.

In a typical operations case, owner / someone with superuser privilege sets up everything as part of the deployment and then hands over the day-to-day operations of different teams who do 24x7 coverage.
Those teams in regular operations support won't be given superuser privilege or owner account because of obvious reasons.
A function with "SECURITY DEFINER" is generally used as a method to hand over only the required privilege just to refresh the subscription.

Thanks and Regards,
Jobin.

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Security Definer functions no longer works in PG14+
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)