MIME-Version: 1.0
In-Reply-To: <CAPRm4pN--N+PRTeyNu_Kak-iHwVxKLetoMAbSKCwRyiVYf5Ojw@mail.gmail.com>
References: <CAPRm4pNU9BLCM1rxr602Y04P1NcUYnmYuqwWwRU5ufc8rGLAqQ@mail.gmail.com>
 <66c140d1-e259-4684-8951-a91313d61493@aklaver.com> <CAPRm4pN--N+PRTeyNu_Kak-iHwVxKLetoMAbSKCwRyiVYf5Ojw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 21 Apr 2024 22:20:05 -0700
Message-ID: <CAKFQuwZ57PfPOudoTSKoiJjhC1Q8WV0xxH7w-7SKHF6KfPs8cw@mail.gmail.com>
Subject: Re: Not able to grant access on pg_signal_backend on azure flexible server
To: Saksham Joshi <sakshamjoshi64@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, 
	"bageshkumarbagimsbi@gmail.com" <bageshkumarbagimsbi@gmail.com>
Content-Type: multipart/alternative; boundary="0000000000001bd15d0616a8971b"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZ57PfPOudoTSKoiJjhC1Q8WV0xxH7w-7SKHF6KfPs8cw%40mail.gmail.com>
Precedence: bulk

--0000000000001bd15d0616a8971b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 b=
ut
> 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=E2=80=99t granted pg_signal_backend to whichever role yo=
u are
executing the above grant command with.  One cannot grant what one does not
have themselves, with the admin option.

David J.

--0000000000001bd15d0616a8971b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sunday, April 21, 2024, Saksham Joshi &lt;<a href=3D"mailto:sakshamjoshi=
64@gmail.com">sakshamjoshi64@gmail.com</a>&gt; wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div dir=3D"auto"><div>Hi,<div dir=3D"auto">I am afraid that&=
#39;s not the case with postgresql 16 since we also tested with postgresql =
15 we are able to run this command( &quot;GRANT pg_signal_backend To &quot;=
our_admin_user&quot;) successfully with our admin user but that&#39;s not t=
he case with postgresql 16 we keep getting the error=C2=A0message=C2=A0 =
9;permission denied to grant role &quot;pg_signal_backend&quot;.</div></div=
></div></blockquote><div><br></div><div>Probably you haven=E2=80=99t grante=
d pg_signal_backend to whichever role you are executing the above grant com=
mand with.=C2=A0 One cannot grant what one does not have themselves, with t=
he admin option.</div><div><br></div><div>David J.</div><div><br></div>

--0000000000001bd15d0616a8971b--