Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-22 Thread Bagesh Kumar Singh
No luck. On Mon, 22 Apr, 2024, 11:42 am David G. Johnston, < david.g.johns...@gmail.com> wrote: > On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi > wrote: > >> We have tried granting it with our admin user also but no avail. >> > > This is how v16+ works in a community installation: > > postgres=

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-21 Thread David G. Johnston
On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi wrote: > We have tried granting it with our admin user also but no avail. > This is how v16+ works in a community installation: postgres=1 # create role cr createrole; CREATE ROLE postgres 2=# set role cr; SET postgres 2=> create role otherrole;

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-21 Thread Saksham Joshi
Hi David, We have tried granting it with our admin user also but no avail. On Mon, 22 Apr 2024, 10:50 David G. Johnston, wrote: > On Sunday, April 21, 2024, Saksham Joshi wrote: > >> Hi, >> I am afraid that's not the case with postgresql 16 since we also tested >> with postgresql 15 we are able

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-21 Thread David G. Johnston
On Sunday, April 21, 2024, Saksham Joshi wrote: > Hi, > I am afraid that's not the case with postgresql 16 since we also tested > with postgresql 15 we are able to run this command( "GRANT > pg_signal_backend To "our_admin_user") successfully with our admin user but > that's not the case with pos

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-21 Thread Saksham Joshi
Hi, I am afraid that's not the case with postgresql 16 since we also tested with postgresql 15 we are able to run this command( "GRANT pg_signal_backend To "our_admin_user") successfully with our admin user but that's not the case with postgresql 16 we keep getting the error message 'permission den

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-19 Thread Adrian Klaver
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

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-19 Thread Tom Lane
Saksham Joshi 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 denie

Not able to grant access on pg_signal_backend on azure flexible server

2024-04-18 Thread Saksham Joshi
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_