Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qx7lD-00GD39-NC
	for pgsql-admin@arkaria.postgresql.org; Sun, 29 Oct 2023 15:31:31 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qx7lB-007xrd-59
	for pgsql-admin@arkaria.postgresql.org; Sun, 29 Oct 2023 15:31:29 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1qx7lA-007xrP-HN
	for pgsql-admin@lists.postgresql.org; Sun, 29 Oct 2023 15:31:28 +0000
Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1qx7l8-002uJ9-3B
	for pgsql-admin@lists.postgresql.org; Sun, 29 Oct 2023 15:31:26 +0000
Received: by mail-yw1-x1133.google.com with SMTP id
 00721157ae682-5a7c95b8d14so26647547b3.3
        for <pgsql-admin@lists.postgresql.org>;
 Sun, 29 Oct 2023 08:31:25 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1698593485; x=1699198285;
 darn=lists.postgresql.org;
        h=in-reply-to:from:references:to:content-language:subject:user-agent
         :mime-version:date:message-id:from:to:cc:subject:date:message-id
         :reply-to;
        bh=WWxjTt1f9FYieC9ADnVhnN6spUMXbMXdQgLZzjAr4Ck=;
        b=aqWb+F5Phu+3GpbFdb/oSe0mLdT4vaD9hUEVq3gQcTD7w38GihNlM/0lG8vI9EnYzM
         7QSo2+8I45TbRYYLDPRZdYc3MKE0kLRQgK+de0JmVOZJaaXvE7gHpPpA/OyCQseon8eH
         1NuzYxIGMW39CiaAdYk0m58FIU2oTKlGip9RoBRQrZuVagypXxOMNJd1aiy5mjoEt/yw
         3B5TYXYZnD/LgUTM9aUsPXd2w0rR2xD9T5VJVPUzx9ndfypBbSvOSfIR5TUiUAglkgnD
         d6i2PLzdoy0U/QkjoqX2+XjjA/aCqLFop9k59aBNIMXwpKlvNJ6jpSNpezBqKThwH5rl
         5VZw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1698593485; x=1699198285;
        h=in-reply-to:from:references:to:content-language:subject:user-agent
         :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject
         :date:message-id:reply-to;
        bh=WWxjTt1f9FYieC9ADnVhnN6spUMXbMXdQgLZzjAr4Ck=;
        b=T6ar97wHte0CVcMLwCk6qF1NV/kzoPW0VkJ1QkTx+ruf9P9SkliC5F0iytVUAeuyNu
         mAsvAp7Bfm6SYTgiwARRsCgyKY4B/P8GJvoXUJjbaiXca+z/yxA48ZgQ/TD0CGfX5ajD
         E71EMb28bwEqoUbrqd4kDVjTks5GOfFfqvwHlr752uLF8+eA05vDj9jxC3avNWlDocWA
         fbVvcoUlFhKGxTaAHZnb4VAWbIv88sCNBxO7eetyM8LTEyttisf4o1YNnOSUtpiY2zgu
         QHi83LCckD1Hmo28kZCq9/c4ymMCrf+J319b6T4ZvCUsci8bNPZzOZ7ZwOF08rdrVdc+
         Rsbg==
X-Gm-Message-State: AOJu0YzuFvZ8A0X7uo8MRmpvAqUihgX3YDG26sR5m7qTo8YQxkIAwhPx
	MZwCpexkwfe0Xaj9og0zJ78eJzIyHG0=
X-Google-Smtp-Source: 
 AGHT+IFWSqAQhq4Dqp1TbiRQ4dY6W3xYAst8C7SIzZuDWAq97mthFTT7lkwraluk+qr8OM4Xe4elqA==
X-Received: by 2002:a81:b143:0:b0:5a7:c72b:812 with SMTP id
 p64-20020a81b143000000b005a7c72b0812mr5620871ywh.17.1698593484961;
        Sun, 29 Oct 2023 08:31:24 -0700 (PDT)
Received: from ?IPV6:2600:1700:bd2c:b810:d564:3b8d:339c:be87?
 ([2600:1700:bd2c:b810:d564:3b8d:339c:be87])
        by smtp.googlemail.com with ESMTPSA id
 q65-20020a819944000000b005af5bb5e840sm3139829ywg.34.2023.10.29.08.31.24
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Sun, 29 Oct 2023 08:31:24 -0700 (PDT)
Content-Type: multipart/alternative;
 boundary="------------04FU8Baw2DQ9eiM00tzIvy8B"
Message-ID: <e465c147-d51a-483a-97b6-7dceab6dcc8b@gmail.com>
Date: Sun, 29 Oct 2023 10:31:24 -0500
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Not able to grant role to User.
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAHOGQfWA-ahoQBUoPrHB8mXyHttGPpCsUMKpngd7+5ShAOpZVA@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CAHOGQfWA-ahoQBUoPrHB8mXyHttGPpCsUMKpngd7+5ShAOpZVA@mail.gmail.com>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/e465c147-d51a-483a-97b6-7dceab6dcc8b%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------04FU8Baw2DQ9eiM00tzIvy8B
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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.
--------------04FU8Baw2DQ9eiM00tzIvy8B
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 10/29/23 10:10, Gambhir Singh wrote:<br>
    <blockquote type="cite"
cite="mid:CAHOGQfWA-ahoQBUoPrHB8mXyHttGPpCsUMKpngd7+5ShAOpZVA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div class="gmail_default"
style="font-family:verdana,sans-serif;font-size:small;color:#000000">Hi,</div>
        <div class="gmail_default"
style="font-family:verdana,sans-serif;font-size:small;color:#000000"><br>
        </div>
        <div class="gmail_default"
style="font-family:verdana,sans-serif;font-size:small;color:#000000">While
          granting role to the user encountering below error.</div>
        <div class="gmail_default"
style="font-family:verdana,sans-serif;font-size:small;color:#000000"><br>
        </div>
        <div class="gmail_default"
style="font-family:verdana,sans-serif;font-size:small;color:#000000">Error:
          Exception: must have admin option role "application_role"</div>
      </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 class="moz-signature">-- <br>
      Born in Arizona, moved to Babylonia.</div>
  </body>
</html>

--------------04FU8Baw2DQ9eiM00tzIvy8B--