Обсуждение: 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"
Thanks & Regards
Gambhir Singh
Gambhir Singh
On 10/29/23 10:10, Gambhir Singh wrote:
We need to see the actual command that you ran, and know what user that you ran it as.
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.
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.
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 detailOn 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.
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