public inbox for [email protected]  

help / color / mirror / Atom feed

From: Saksham Joshi <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Not able to grant access on pg_signal_backend on azure flexible server
Date: Mon, 22 Apr 2024 10:40:24 +0530
Message-ID: <CAPRm4pN--N+PRTeyNu_Kak-iHwVxKLetoMAbSKCwRyiVYf5Ojw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAPRm4pNU9BLCM1rxr602Y04P1NcUYnmYuqwWwRU5ufc8rGLAqQ@mail.gmail.com>
	<[email protected]>

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, <[email protected]> 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
> [email protected]
>
>

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]
  Subject: Re: Not able to grant access on pg_signal_backend on azure flexible server
  In-Reply-To: <CAPRm4pN--N+PRTeyNu_Kak-iHwVxKLetoMAbSKCwRyiVYf5Ojw@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