pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNot able to grant role to User.
7+ messages / 6 participants
[nested] [flat]
* Not able to grant role to User.
@ 2023-10-29 15:10 Gambhir Singh <gambhir.singh05@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Gambhir Singh @ 2023-10-29 15:10 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
While granting role to the user encountering below error.
Error: Exception: must have admin option role "application_role"
--
Thanks & Regards
Gambhir Singh
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Not able to grant role to User.
@ 2023-10-29 15:31 Ron <ronljohnsonjr@gmail.com>
parent: Gambhir Singh <gambhir.singh05@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Ron @ 2023-10-29 15:31 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 10/29/23 10:10, Gambhir Singh wrote:
> Hi,
>
> While granting role to the user encountering below error.
>
> Error: Exception: must have admin option role "application_role"
We need to see the actual command that you ran, and know what user that you
ran it as.
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Not able to grant role to User.
@ 2023-10-29 15:48 ashter lab <ashter.lab@gmail.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: ashter lab @ 2023-10-29 15:48 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hi,
Can you please share Enterprise posrgresql server license cost detail
On Sun, Oct 29, 2023, 8:31 PM Ron <ronljohnsonjr@gmail.com> wrote:
> On 10/29/23 10:10, Gambhir Singh wrote:
>
> Hi,
>
> While granting role to the user encountering below error.
>
> Error: Exception: must have admin option role "application_role"
>
>
> We need to see the actual command that you ran, and know what user that
> you ran it as.
>
>
> --
> Born in Arizona, moved to Babylonia.
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Not able to grant role to User.
@ 2023-10-29 15:56 Ron <ronljohnsonjr@gmail.com>
parent: ashter lab <ashter.lab@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Ron @ 2023-10-29 15:56 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Ni, I can't Enterprise DB can, though.
On 10/29/23 10:48, ashter lab wrote:
> Hi,
> Can you please share Enterprise posrgresql server license cost detail
>
> On Sun, Oct 29, 2023, 8:31 PM Ron <ronljohnsonjr@gmail.com> wrote:
>
> On 10/29/23 10:10, Gambhir Singh wrote:
>> Hi,
>>
>> While granting role to the user encountering below error.
>>
>> Error: Exception: must have admin option role "application_role"
>
> We need to see the actual command that you ran, and know what user
> that you ran it as.
>
>
> --
> Born in Arizona, moved to Babylonia.
>
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Not able to grant role to User.
@ 2023-10-29 23:04 Jwiencek3 <jwiencek3@comcast.net>
parent: ashter lab <ashter.lab@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Jwiencek3 @ 2023-10-29 23:04 UTC (permalink / raw)
To: ashter lab <ashter.lab@gmail.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
--Apple-Mail-06F47637-9242-4AB5-9863-65BA882FD9C3
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Is this a follow up to the grant issue?<br>=
<br><div dir=3D"ltr">Sent from my iPad</div><div dir=3D"ltr"><br><blockquote=
type=3D"cite">On Oct 29, 2023, at 10:48 AM, ashter lab <ashter.lab@gmail=
.com> wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=
=3D"ltr">=EF=BB=BF<div dir=3D"auto">Hi,<div dir=3D"auto">Can you please shar=
e Enterprise posrgresql server license cost detail</div></div><br><div=
class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, Oct 29,=
2023, 8:31 PM Ron <<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnso=
njr@gmail.com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
=20
=20
=20
<div>
On 10/29/23 10:10, Gambhir Singh wrote:<br>
<blockquote type=3D"cite">
=20
<div dir=3D"ltr">
<div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif=
;font-size:small;color:#000000">Hi,</div>
<div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif=
;font-size:small;color:#000000"><br>
</div>
<div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif=
;font-size:small;color:#000000">While
granting role to the user encountering below error.</div>
<div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif=
;font-size:small;color:#000000"><br>
</div>
<div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif=
;font-size:small;color:#000000">Error:
Exception: must have admin option role "application_role"</di=
v>
</div>
</blockquote>
<br>
We need to see the actual command that you ran, and know what user
that you ran it as.<br>
<br>
<br>
<div>-- <br>
Born in Arizona, moved to Babylonia.</div>
</div>
</blockquote></div>
</div></blockquote></body></html>=
--Apple-Mail-06F47637-9242-4AB5-9863-65BA882FD9C3--
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Not able to grant role to User.
@ 2023-10-30 03:48 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Gambhir Singh <gambhir.singh05@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Laurenz Albe @ 2023-10-30 03:48 UTC (permalink / raw)
To: Gambhir Singh <gambhir.singh05@gmail.com>; pgsql-admin@lists.postgresql.org
On Sun, 2023-10-29 at 20:40 +0530, Gambhir Singh wrote:
> While granting role to the user encountering below error.
>
> Error: Exception: must have admin option role "application_role"
This is not a PostgreSQL error message.
You should ask the vendor of the software that generated this error message.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Not able to grant role to User.
@ 2023-10-30 04:11 Tom Lane <tgl@sss.pgh.pa.us>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2023-10-30 04:11 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Gambhir Singh <gambhir.singh05@gmail.com>; pgsql-admin@lists.postgresql.org
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Sun, 2023-10-29 at 20:40 +0530, Gambhir Singh wrote:
>> Error: Exception: must have admin option role "application_role"
> This is not a PostgreSQL error message.
It could be a sloppily transcribed version of our pre-v16 message:
if (!have_createrole_privilege() &&
!is_admin_of_role(grantorId, roleid))
ereport(ERROR,
(errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
errmsg("must have admin option on role \"%s\"",
rolename)));
If that's what it is though, any effort at reading the documentation
would have turned up the relevant point: the would-be grantor needs
to have been granted the role WITH ADMIN OPTION in order to be able
to grant it to (or revoke it from) someone else. Or else be
superuser or someone with CREATEROLE.
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2023-10-30 04:11 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-29 15:10 Not able to grant role to User. Gambhir Singh <gambhir.singh05@gmail.com>
2023-10-29 15:31 ` Ron <ronljohnsonjr@gmail.com>
2023-10-29 15:48 ` ashter lab <ashter.lab@gmail.com>
2023-10-29 15:56 ` Ron <ronljohnsonjr@gmail.com>
2023-10-29 23:04 ` Jwiencek3 <jwiencek3@comcast.net>
2023-10-30 03:48 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-30 04:11 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox