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

--0000000000007465e50616a8757f
Content-Type: text/plain; charset="UTF-8"

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".Also,In postgre 16
only the current users of the database are able to close the
connections.Can you help on this please?

On Fri, 19 Apr 2024, 19:50 Adrian Klaver, <adrian.klaver@aklaver.com> wrote:

> On 4/18/24 22:48, Saksham Joshi wrote:
> > 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.
>
>
> https://www.postgresql.org/docs/current/predefined-roles.html
>
> "PostgreSQL provides a set of predefined roles that provide access to
> certain, commonly needed, privileged capabilities and information.
> Administrators (including roles that have the CREATEROLE privilege) can
> GRANT these roles to users and/or other roles in their environment,
> providing those users with access to the specified capabilities and
> information."
>
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

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

<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 the case with p=
ostgresql 16 we keep getting the error=C2=A0message=C2=A0 &#39;permission d=
enied to grant role &quot;pg_signal_backend&quot;.Also,In postgre 16 only t=
he current users of the database are able to close the connections.Can you =
help on=C2=A0this please?</div><br><div class=3D"gmail_quote"><div dir=3D"l=
tr" class=3D"gmail_attr">On Fri, 19 Apr 2024, 19:50 Adrian Klaver, &lt;<a h=
ref=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt; =
wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8e=
x;border-left:1px #ccc solid;padding-left:1ex">On 4/18/24 22:48, Saksham Jo=
shi wrote:<br>
&gt; Hi,<br>
&gt; We have created an azure postgresql flexible server and we have added =
an <br>
&gt; ad admin as a user and Created our database using this admin <br>
&gt; user.However,When are running this command: &#39;Grant pg_signal_backe=
nd To <br>
&gt; adminUser&#39; we are getting an error that says &#39;permission denie=
d to grant <br>
&gt; role &quot;pg_signal_backend&quot;.While this is strange the admin use=
r is infact <br>
&gt; the owner of the said database and we don&#39;t have any other user th=
at <br>
&gt; have the said privileges.<br>
<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/predefined-roles.html" r=
el=3D"noreferrer noreferrer" target=3D"_blank">https://www.postgresql.org/d=
ocs/current/predefined-roles.html</a><br>
<br>
&quot;PostgreSQL provides a set of predefined roles that provide access to =
<br>
certain, commonly needed, privileged capabilities and information. <br>
Administrators (including roles that have the CREATEROLE privilege) can <br=
>
GRANT these roles to users and/or other roles in their environment, <br>
providing those users with access to the specified capabilities and <br>
information.&quot;<br>
<br>
<br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank" rel=3D"noref=
errer">adrian.klaver@aklaver.com</a><br>
<br>
</blockquote></div></div></div>

--0000000000007465e50616a8757f--