public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Saksham Joshi <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Not able to grant access on pg_signal_backend on azure flexible server
Date: Sun, 21 Apr 2024 22:20:05 -0700
Message-ID: <CAKFQuwZ57PfPOudoTSKoiJjhC1Q8WV0xxH7w-7SKHF6KfPs8cw@mail.gmail.com> (raw)
In-Reply-To: <CAPRm4pN--N+PRTeyNu_Kak-iHwVxKLetoMAbSKCwRyiVYf5Ojw@mail.gmail.com>
References: <CAPRm4pNU9BLCM1rxr602Y04P1NcUYnmYuqwWwRU5ufc8rGLAqQ@mail.gmail.com>
	<[email protected]>
	<CAPRm4pN--N+PRTeyNu_Kak-iHwVxKLetoMAbSKCwRyiVYf5Ojw@mail.gmail.com>

On Sunday, April 21, 2024, Saksham Joshi <[email protected]> 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.

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Not able to grant access on pg_signal_backend on azure flexible server
  In-Reply-To: <CAKFQuwZ57PfPOudoTSKoiJjhC1Q8WV0xxH7w-7SKHF6KfPs8cw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox