public inbox for [email protected]help / color / mirror / Atom feed
Re: Not able to grant access on pg_signal_backend on azure flexible server 4+ messages / 3 participants [nested] [flat]
* Re: Not able to grant access on pg_signal_backend on azure flexible server @ 2024-04-22 05:20 David G. Johnston <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: David G. Johnston @ 2024-04-22 05:20 UTC (permalink / raw) To: Saksham Joshi <[email protected]>; +Cc: Adrian Klaver <[email protected]>; [email protected] <[email protected]>; [email protected] <[email protected]> On Sunday, April 21, 2024, Saksham Joshi <[email protected]> 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 postgresql 16 we keep getting the error message > 'permission denied to grant role "pg_signal_backend". > Probably you haven’t granted pg_signal_backend to whichever role you are executing the above grant command with. One cannot grant what one does not have themselves, with the admin option. David J. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Not able to grant access on pg_signal_backend on azure flexible server @ 2024-04-22 05:48 Saksham Joshi <[email protected]> parent: David G. Johnston <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Saksham Joshi @ 2024-04-22 05:48 UTC (permalink / raw) To: David G. Johnston <[email protected]>; +Cc: Adrian Klaver <[email protected]>; [email protected]; [email protected] 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, <[email protected]> wrote: > On Sunday, April 21, 2024, Saksham Joshi <[email protected]> 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 postgresql 16 we keep getting the error message >> 'permission denied to grant role "pg_signal_backend". >> > > Probably you haven’t granted pg_signal_backend to whichever role you are > executing the above grant command with. One cannot grant what one does not > have themselves, with the admin option. > > David J. > > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Not able to grant access on pg_signal_backend on azure flexible server @ 2024-04-22 06:11 David G. Johnston <[email protected]> parent: Saksham Joshi <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: David G. Johnston @ 2024-04-22 06:11 UTC (permalink / raw) To: Saksham Joshi <[email protected]>; +Cc: Adrian Klaver <[email protected]>; [email protected]; [email protected] On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi <[email protected]> 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; CREATE ROLE postgres 2=> grant pg_signal_backend to otherrole; ERROR: permission denied to grant role "pg_signal_backend" DETAIL: Only roles with the ADMIN option on role "pg_signal_backend" may grant this role. postgres 1=# grant pg_signal_backend to cr with admin option; GRANT ROLE postgres 2=> grant pg_signal_backend to otherrole; GRANT ROLE David J. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Not able to grant access on pg_signal_backend on azure flexible server @ 2024-04-22 07:20 Bagesh Kumar Singh <[email protected]> parent: David G. Johnston <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Bagesh Kumar Singh @ 2024-04-22 07:20 UTC (permalink / raw) To: David G. Johnston <[email protected]>; +Cc: Saksham Joshi <[email protected]>; Adrian Klaver <[email protected]>; [email protected] No luck. On Mon, 22 Apr, 2024, 11:42 am David G. Johnston, < [email protected]> wrote: > On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi <[email protected]> > 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; > CREATE ROLE > postgres 2=> grant pg_signal_backend to otherrole; > ERROR: permission denied to grant role "pg_signal_backend" > DETAIL: Only roles with the ADMIN option on role "pg_signal_backend" may > grant this role. > > postgres 1=# grant pg_signal_backend to cr with admin option; > GRANT ROLE > > postgres 2=> grant pg_signal_backend to otherrole; > GRANT ROLE > > David J. > > ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-04-22 07:20 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-04-22 05:20 Re: Not able to grant access on pg_signal_backend on azure flexible server David G. Johnston <[email protected]> 2024-04-22 05:48 ` Saksham Joshi <[email protected]> 2024-04-22 06:11 ` David G. Johnston <[email protected]> 2024-04-22 07:20 ` Bagesh Kumar Singh <[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