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

No luck.

On Mon, 22 Apr, 2024, 11:42 am David G. Johnston, <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi <sakshamjoshi64(at)gmail(dot)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.
>
>