Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi David,
We have tried granting it with our admin user also but no avail.

On Mon, 22 Apr 2024, 10:50 David G. Johnston, <david.g.johnston@xxxxxxxxx> wrote:
On Sunday, April 21, 2024, Saksham Joshi <sakshamjoshi64@xxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux