From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Saksham Joshi <sakshamjoshi64(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org, "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 13:38:50 |
Message-ID: | 2131246.1713533930@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Saksham Joshi <sakshamjoshi64(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-04-19 14:20:16 | Re: Not able to grant access on pg_signal_backend on azure flexible server |
Previous Message | Justin Clift | 2024-04-19 10:05:26 | Re: SSPI Feature Request |