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 ) id 1qxJGK-00HXXr-VH for pgsql-admin@arkaria.postgresql.org; Mon, 30 Oct 2023 03:48:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qxJGJ-00AofI-BA for pgsql-admin@arkaria.postgresql.org; Mon, 30 Oct 2023 03:48:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qxJGI-00AofA-RW for pgsql-admin@lists.postgresql.org; Mon, 30 Oct 2023 03:48:23 +0000 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qxJGB-003lM7-UN for pgsql-admin@lists.postgresql.org; Mon, 30 Oct 2023 03:48:21 +0000 Received: by mail-wr1-x430.google.com with SMTP id ffacd0b85a97d-32dd70c5401so2548320f8f.0 for ; Sun, 29 Oct 2023 20:48:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1698637694; x=1699242494; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=SFF2J57cmZkhgiheR/X9qRP9Uhn863dZfQzkS5f09pY=; b=gGkyniuz38B7J+OzBJXpbtvs+BEGylKjsHoPj6CgquWvaDByiuUeFN3Vc7pkTzr2iT 8ERXkarivW4FBn0vebaII6ezl52ZP0fkp0oQWElZM4YiwMlu/+pTSw9Uo9x21vLKeLD0 xwBY9Ji5Wwm8JcF8URl4ki806SXq/C2sg5nceaveDlWKKuXojWpngG8M1EW+I0gwSyBk fvv7M8g1F7B4jOxSH7wYP2z7lBBTJTVs4d9e84SMvn/Bbm8z+fCcXVZUhROc8K0dzupB CJRcd7jnJxVXwO/yer/F4LO/60R3fd5Iy3wYxsoE1RIqn3DrSgPVE8Jqwjr01OR+rX50 HWPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698637694; x=1699242494; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=SFF2J57cmZkhgiheR/X9qRP9Uhn863dZfQzkS5f09pY=; b=VzKiXj4CDBVSA7XhRgAdm6JPH7oke8ZJj1Au+hiMRedRFyBmhwmlzG05QApxK5Pbh+ 4S+MTMfQUAAbN3vgXOzbwjdWav/2Qmm3kfxedK3vCdqMoMRuaSK6eYl1k/Dcb1oV2ykm haqfhp1yDDiU538XTvMl5xsI3IXrRzqIKGHK/5vhUdujNUp1014yKH/eRb0OYZMRz5qg FzsLd36Dx6Spep7MHsftmlAlPj3r2WYtExCONBOQoauRsfdv5MQd830v8qOKYH8Megki KStuxLOy66owFMa/ihcRtBB8TQz9wqlTHYpWsdLR5dQwEGCrL9lrmsOHqgE43BC2+uR/ TGSw== X-Gm-Message-State: AOJu0YxRdbnSO+TKPRtI6QfXXf4UMDFZXXA2KSEBrmUFLxkDGt6mmFM/ 6m9MbQKsL2wCJbw+hCjQndarTw== X-Google-Smtp-Source: AGHT+IGL4krNz8QCDBqurwvSMLSzXdHzTE62JdtONcrBkSTG8GdL9nOFf3D12kitZppRByt6DgYTqw== X-Received: by 2002:a5d:518c:0:b0:32d:d756:2cd3 with SMTP id k12-20020a5d518c000000b0032dd7562cd3mr6216553wrv.22.1698637693899; Sun, 29 Oct 2023 20:48:13 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:eb44:666e:9432:b55d:2553]) by smtp.gmail.com with ESMTPSA id z9-20020a5d44c9000000b00327b5ca093dsm7275768wrr.117.2023.10.29.20.48.13 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 29 Oct 2023 20:48:13 -0700 (PDT) Message-ID: <7d778cce665a121629d1eb41dde4774adf4d22d0.camel@cybertec.at> Subject: Re: Not able to grant role to User. From: Laurenz Albe To: Gambhir Singh , pgsql-admin@lists.postgresql.org Date: Mon, 30 Oct 2023 04:48:13 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2023-10-29 at 20:40 +0530, Gambhir Singh wrote: > While granting role to the user encountering below=C2=A0error. >=20 > Error: Exception: must have admin option=C2=A0role "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