public inbox for [email protected]help / color / mirror / Atom feed
Not able to grant access on pg_signal_backend on azure flexible server 3+ messages / 3 participants [nested] [flat]
* Not able to grant access on pg_signal_backend on azure flexible server @ 2024-04-19 05:48 Saksham Joshi <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Saksham Joshi @ 2024-04-19 05:48 UTC (permalink / raw) To: [email protected]; +Cc: [email protected] <[email protected]> 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Not able to grant access on pg_signal_backend on azure flexible server @ 2024-04-19 13:38 Tom Lane <[email protected]> parent: Saksham Joshi <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Tom Lane @ 2024-04-19 13:38 UTC (permalink / raw) To: Saksham Joshi <[email protected]>; +Cc: [email protected]; [email protected] <[email protected]> Saksham Joshi <[email protected]> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Not able to grant access on pg_signal_backend on azure flexible server @ 2024-04-19 14:20 Adrian Klaver <[email protected]> parent: Saksham Joshi <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Adrian Klaver @ 2024-04-19 14:20 UTC (permalink / raw) To: Saksham Joshi <[email protected]>; [email protected]; +Cc: [email protected] <[email protected]> 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] ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-04-19 14:20 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-04-19 05:48 Not able to grant access on pg_signal_backend on azure flexible server Saksham Joshi <[email protected]> 2024-04-19 13:38 ` Tom Lane <[email protected]> 2024-04-19 14:20 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox