Обсуждение: Not able to grant role to User.

Hi,

While granting role to the user encountering below error.

Error: Exception: must have admin option role "application_role"

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.

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

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