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

On Sunday, April 21, 2024, Saksham Joshi <sakshamjoshi64@gmail.com> wrote:

Hi,

I am afraid that's not the case with postgresql 16 since we also tested with postgresql 15 we are able to run this command( "GRANT pg_signal_backend To "our_admin_user") successfully with our admin user but that's not the case with postgresql 16 we keep getting the error message  'permission denied to grant role "pg_signal_backend".

Probably you haven’t granted pg_signal_backend to whichever role you are executing the above grant command with.  One cannot grant what one does not have themselves, with the admin option.

David J.