[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Not able to grant access on pg_signal_backend on azure flexible server
From:       Bagesh Kumar Singh <bageshkumarbagimsbi () gmail ! com>
Date:       2024-04-22 7:32:55
Message-ID: CAJT4eW0DL-sXFdG1vEa25zAdBQrJf0RHHqOQ_s_XfYGrAJkJ-Q () mail ! gmail ! com
[Download RAW message or body]

No luck.

On Mon, 22 Apr, 2024, 11:42 am David G. Johnston, <
david.g.johnston@gmail.com> wrote:

> On Sun, Apr 21, 2024 at 10:49 PM Saksham Joshi <sakshamjoshi64@gmail.com>
> 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.
>
>

[Attachment #3 (text/html)]

<div dir="auto">No luck.  </div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Mon, 22 Apr, 2024, 11:42 am David G. Johnston, &lt;<a \
href="mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><div \
class="gmail_default" style="font-family:arial,helvetica,sans-serif"><span \
style="font-family:Arial,Helvetica,sans-serif">On Sun, Apr 21, 2024 at 10:49 PM \
Saksham Joshi &lt;<a href="mailto:sakshamjoshi64@gmail.com" target="_blank" \
rel="noreferrer">sakshamjoshi64@gmail.com</a>&gt; wrote:</span><br></div></div><div \
class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="auto"><div \
dir="auto">We have tried granting it with our admin user also but no \
avail.</div></div></blockquote><div><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">This  is how v16+ works in a community \
installation:</div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">postgres=1 # create role cr \
createrole;<br>CREATE ROLE<br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">postgres 2=# set role \
cr;<br>SET<br><br>postgres 2=&gt; create role otherrole;<br>CREATE ROLE<br>postgres \
2=&gt; grant pg_signal_backend to otherrole;<br>ERROR:   permission denied to grant \
role &quot;pg_signal_backend&quot;<br>DETAIL:   Only roles with the ADMIN option on \
role &quot;pg_signal_backend&quot; may grant this role.<br><br></div><div \
class="gmail_default" style="font-family:arial,helvetica,sans-serif"><div \
class="gmail_default">postgres 1=# grant pg_signal_backend to cr with admin \
option;<br>GRANT ROLE<br></div><div class="gmail_default"><br></div></div><div \
class="gmail_default" style="font-family:arial,helvetica,sans-serif">postgres 2=&gt; \
grant pg_signal_backend to otherrole;<br>GRANT ROLE<br><br></div><div \
class="gmail_default" style="font-family:arial,helvetica,sans-serif">David \
J.</div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div></div></div> \
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]