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

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

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@gmail.com>
wrote:

> 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=E2=80=99t granted pg_signal_backend to whichever role =
you are
> executing the above grant command with.  One cannot grant what one does n=
ot
> have themselves, with the admin option.
>
> David J.
>
>

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

<div dir=3D"auto">Hi David,<div dir=3D"auto">We have tried granting it with=
 our admin user also but no avail.</div></div><br><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 22 Apr 2024, 10:50 David G.=
 Johnston, &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.johnst=
on@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Sund=
ay, April 21, 2024, Saksham Joshi &lt;<a href=3D"mailto:sakshamjoshi64@gmai=
l.com" target=3D"_blank" rel=3D"noreferrer">sakshamjoshi64@gmail.com</a>&gt=
; wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bo=
rder-left:1px #ccc solid;padding-left:1ex"><div dir=3D"auto"><div>Hi,<div d=
ir=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;GRAN=
T pg_signal_backend To &quot;our_admin_user&quot;) successfully with our ad=
min user but that&#39;s not the case with postgresql 16 we keep getting the=
 error=C2=A0message=C2=A0 &#39;permission denied to grant role &quot;pg_sig=
nal_backend&quot;.</div></div></div></blockquote><div><br></div><div>Probab=
ly you haven=E2=80=99t granted pg_signal_backend to whichever role you are =
executing the above grant command with.=C2=A0 One cannot grant what one doe=
s not have themselves, with the admin option.</div><div><br></div><div>Davi=
d J.</div><div><br></div>
</blockquote></div>

--0000000000009fc62b0616a8fe29--