No luck. On Mon, 22 Apr, 2024, 11:42 am David G. Johnston, < david.g.johns...@gmail.com> wrote:
> On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi <sakshamjosh...@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. > >
