From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Saksham Joshi <sakshamjoshi64(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Cc: | "bageshkumarbagimsbi(at)gmail(dot)com" <bageshkumarbagimsbi(at)gmail(dot)com> |
Subject: | Re: Not able to grant access on pg_signal_backend on azure flexible server |
Date: | 2024-04-19 14:20:16 |
Message-ID: | 66c140d1-e259-4684-8951-a91313d61493@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-04-19 14:48:13 | Re: Can you refresh a materialized view from a materialized view on another server? |
Previous Message | Tom Lane | 2024-04-19 13:38:50 | Re: Not able to grant access on pg_signal_backend on azure flexible server |