Re: Not able to grant access on pg_signal_backend on azure flexible server

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Not able to grant access on pg_signal_backend on azure flexible server
Дата
Msg-id CAKFQuwawKpd8ce=MyVwAuv0qJVjoVAEEo=1XFB=ggeZeK0vSMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Not able to grant access on pg_signal_backend on azure flexible server  (Saksham Joshi <sakshamjoshi64@gmail.com>)
Ответы Re: Not able to grant access on pg_signal_backend on azure flexible server
Список pgsql-general
On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi <sakshamjoshi64@gmail.com> wrote:
We have tried granting it with our admin user also but no avail.

This is how v16+ works in a community installation:

postgres=1 # create role cr createrole;
CREATE ROLE

postgres 2=# set role cr;
SET

postgres 2=> create role otherrole;
CREATE ROLE
postgres 2=> grant pg_signal_backend to otherrole;
ERROR:  permission denied to grant role "pg_signal_backend"
DETAIL:  Only roles with the ADMIN option on role "pg_signal_backend" may grant this role.

postgres 1=# grant pg_signal_backend to cr with admin option;
GRANT ROLE

postgres 2=> grant pg_signal_backend to otherrole;
GRANT ROLE

David J.

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

Предыдущее
От: Saksham Joshi
Дата:
Сообщение: Re: Not able to grant access on pg_signal_backend on azure flexible server
Следующее
От: Bagesh Kumar Singh
Дата:
Сообщение: Re: Not able to grant access on pg_signal_backend on azure flexible server