From: Tom Lane <tgl@sss.pgh.pa.us>
To: Saksham Joshi <sakshamjoshi64@gmail.com>
cc: pgsql-general@lists.postgresql.org,
        "bageshkumarbagimsbi@gmail.com" <bageshkumarbagimsbi@gmail.com>
Subject: Re: Not able to grant access on pg_signal_backend on azure flexible server
In-reply-to: <CAPRm4pNU9BLCM1rxr602Y04P1NcUYnmYuqwWwRU5ufc8rGLAqQ@mail.gmail.com>
References: <CAPRm4pNU9BLCM1rxr602Y04P1NcUYnmYuqwWwRU5ufc8rGLAqQ@mail.gmail.com>
Comments: In-reply-to Saksham Joshi <sakshamjoshi64@gmail.com>
	message dated "Fri, 19 Apr 2024 11:18:10 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2131245.1713533930.1@sss.pgh.pa.us>
Date: Fri, 19 Apr 2024 09:38:50 -0400
Message-ID: <2131246.1713533930@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/2131246.1713533930%40sss.pgh.pa.us>
Precedence: bulk

Saksham Joshi <sakshamjoshi64@gmail.com> writes:
> 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.

Being the owner of a database isn't an especially privileged thing
in Postgres.  In particular, it does not grant you any powers over
installation-wide objects such as roles.

			regards, tom lane