Re: Not able to grant access on pg_signal_backend on azure flexible server - Mailing list pgsql-general

From Tom Lane
Subject Re: Not able to grant access on pg_signal_backend on azure flexible server
Date
Msg-id 2131246.1713533930@sss.pgh.pa.us
Whole thread Raw
In response to Not able to grant access on pg_signal_backend on azure flexible server  (Saksham Joshi <sakshamjoshi64@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: SSPI Feature Request
Next
From: Adrian Klaver
Date:
Subject: Re: Not able to grant access on pg_signal_backend on azure flexible server