public inbox for [email protected]
help / color / mirror / Atom feedRe: 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]>
2024-04-22 05:48 ` Re: Not able to grant access on pg_signal_backend on azure flexible server Saksham Joshi <[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: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 ` Re: Not able to grant access on pg_signal_backend on azure flexible server 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 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 ` Re: Not able to grant access on pg_signal_backend on azure flexible server Saksham Joshi <[email protected]>
@ 2024-04-22 06:11 ` David G. Johnston <[email protected]>
2024-04-22 07:20 ` Re: Not able to grant access on pg_signal_backend on azure flexible server Bagesh Kumar Singh <[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 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 ` Re: Not able to grant access on pg_signal_backend on azure flexible server Saksham Joshi <[email protected]>
2024-04-22 06:11 ` Re: Not able to grant access on pg_signal_backend on azure flexible server David G. Johnston <[email protected]>
@ 2024-04-22 07:20 ` Bagesh Kumar Singh <[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