public inbox for [email protected]
help / color / mirror / Atom feedNot 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]>
2024-04-19 13:38 ` Re: Not able to grant access on pg_signal_backend on azure flexible server Tom Lane <[email protected]>
2024-04-19 14:20 ` Re: Not able to grant access on pg_signal_backend on azure flexible server Adrian Klaver <[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 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]>
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 05:48 Not able to grant access on pg_signal_backend on azure flexible server Saksham Joshi <[email protected]>
@ 2024-04-19 14:20 ` Adrian Klaver <[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