MIME-Version: 1.0
From: Saksham Joshi <sakshamjoshi64@gmail.com>
Date: Fri, 19 Apr 2024 11:18:10 +0530
Message-ID: <CAPRm4pNU9BLCM1rxr602Y04P1NcUYnmYuqwWwRU5ufc8rGLAqQ@mail.gmail.com>
Subject: Not able to grant access on pg_signal_backend on azure flexible server
To: pgsql-general@lists.postgresql.org
Cc: "bageshkumarbagimsbi@gmail.com" <bageshkumarbagimsbi@gmail.com>
Content-Type: multipart/alternative; boundary="000000000000afb1ee06166ca237"
Archived-At: <https://www.postgresql.org/message-id/CAPRm4pNU9BLCM1rxr602Y04P1NcUYnmYuqwWwRU5ufc8rGLAqQ%40mail.gmail.com>
Precedence: bulk

--000000000000afb1ee06166ca237
Content-Type: text/plain; charset="UTF-8"

Hi,
We have created an azure postgresql flexible server and we have added an ad
admin as a user and Created our database using this admin user.However,When
are running this command: 'Grant pg_signal_backend To adminUser' we are
getting an error that says 'permission denied to grant role
"pg_signal_backend".While this is strange the admin user is infact the
owner of the said database and we don't have any other user that have the
said privileges.

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

<div dir=3D"auto">Hi,<div dir=3D"auto">We have created an azure postgresql =
flexible server and we have added an ad admin as a user and Created our dat=
abase using this admin user.However,When are running this command: &#39;Gra=
nt pg_signal_backend To adminUser&#39; we are getting an error that says &#=
39;permission denied to grant role &quot;pg_signal_backend&quot;.While this=
 is strange the admin user is infact the owner of the said database and we =
don&#39;t have any other user that have the said privileges.</div></div>

--000000000000afb1ee06166ca237--