| 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: | Whole Thread | Raw Message | 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 |