On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi <sakshamjoshi64@xxxxxxxxx> 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
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.
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
GRANT ROLE
postgres 2=> grant pg_signal_backend to otherrole;
GRANT ROLE
GRANT ROLE
David J.
