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 1soSuo-00BSzH-J1 for pgsql-general@arkaria.postgresql.org; Wed, 11 Sep 2024 19:22:11 +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 1soSuo-006TeI-4d for pgsql-general@arkaria.postgresql.org; Wed, 11 Sep 2024 19:22:10 +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 ) id 1soSun-006Tdu-NA for pgsql-general@lists.postgresql.org; Wed, 11 Sep 2024 19:22:09 +0000 Received: from mail-oa1-x2e.google.com ([2001:4860:4864:20::2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1soSuk-000gJv-OZ for pgsql-general@lists.postgresql.org; Wed, 11 Sep 2024 19:22:08 +0000 Received: by mail-oa1-x2e.google.com with SMTP id 586e51a60fabf-27b7a1480bdso81725fac.2 for ; Wed, 11 Sep 2024 12:22:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726082526; x=1726687326; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ZYzpcQ2dJc416nPx6uQj6+Asdu8OwNWSNsKVMQo0d7I=; b=GOz+rWkTHKjs2rGAAbONZKCEkRnffxbBmVw8vC+H3EG27mcy4P0u0ErImc9WxmCMnh Ht3XMpfS3FQ9RdFurOEGS9oFt2NWaNLW6SLz1QPa48JutK0ZHXcyZvIjTh1VeQyfbpGx aOb5vRuPyLlq+yzrvY9SFyofzE5tKwWhtBNflDudllpTnS4zRGNswLgrKaimsjaEd6OV ZrIAg7frYuRDJeJM3vzdmz6Iz3oXHrbq5+en4njaQvAqXQnCrA5O5nFEqwhGxmPfK3dV ul6kRHjwqX8rjibLzM4/CBXys+O0bN3xax5K4G8YB7sa/7mCWzNMCAbzA2Gnk8PMFZQJ ZJrA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726082526; x=1726687326; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ZYzpcQ2dJc416nPx6uQj6+Asdu8OwNWSNsKVMQo0d7I=; b=Z989+h2jgSlNeafKfaHP142t4UavO7mzb5jXkpcPcxTDr2lCucnUbWFSSCybRnEhFM AA883U9bVD+wEsLzwNH/g+2nxpLuknskdVRRw0EFvLuojkHYQA0FJ8AA0exGqyOenh1a XQ8LNDfT2VyNRz7C2MljrQ89Q2vW3nIJSnRoXDa82u8aj7m0d3aYzDNfDIgUqf6v+jKp s8ZTZMkLiwx9B8V70alZAumgOWxWqVWSrt9Tdk36fXAPFXbHM/chGOkvxNQDG986VSq9 a3fDggWoRzgBMTKnzFkqX77gft2gg9b8lDHqxWvjq1Ye33lleEqjVHDJ1+ch6CJro/BH tSIg== X-Forwarded-Encrypted: i=1; AJvYcCWA4o0ZrMuTgLr5JV58N0iCb88uoIjCZkRj3s4HtVXGgsTgA+YfDhxqo8NVxNU8zarmNlFa07FAdH95PXQJ@lists.postgresql.org X-Gm-Message-State: AOJu0YxnVctzPyTCRujLIPiyr3zgOZWZhY0ckJwDVIkGXAspNW62TR3r thnCxwSj1W0eDL2C+/kAnZ7EOGPWSRqkjJ4s64X8eih/xSAz250t+LLvVl8gcYDeYH4ShaYjAYm W20AsXc5DRpjpJNonyANcxpPK5pQ= X-Google-Smtp-Source: AGHT+IGqNkWN/Uu8rV/Ugm8/M1hY65uTgd19TOe29U8dPHNYqIvgqAawBOdmdETkwAZkxoaFUXukgHS+YLeRpFsGS+A= X-Received: by 2002:a05:6870:20c:b0:270:2c3:f362 with SMTP id 586e51a60fabf-27c3f66f419mr258014fac.32.1726082526025; Wed, 11 Sep 2024 12:22:06 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Wed, 11 Sep 2024 12:21:56 -0700 Message-ID: Subject: Re: Backward compat issue with v16 around ROLEs To: Wolfgang Walther Cc: Dominique Devienne , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000d120910621dce7ba" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d120910621dce7ba Content-Type: text/plain; charset="UTF-8" On Wed, Sep 11, 2024, 12:17 Wolfgang Walther wrote: > Dominique Devienne: > > Hi David. I did as you suggested, and it fails the same way. Did I > > misunderstand you? --DD > > > > [..] > > > > ddevienne=> grant dd_owner to dd_admin with admin option; -- <<<<<<<< > > I think this needs to be the other way around: > > grant dd_admin to dd_owner with admin option; > > Best, > > Wolfgang > Probably, intend to get those reversed and wasn't in a position to experiment. In any case fixing the with admin error is the correct approach. David J. > --000000000000d120910621dce7ba Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Wed, Sep 11, 2024, 12:17 Wolfgang Walther <walther@technowledgy.de> wrote= :
Dominique Devienne:
> Hi David. I did as you suggested, and it fails the same way. Did I
> misunderstand you? --DD
>
> [..]
>
> ddevienne=3D> grant dd_owner to dd_admin with admin option; -- <= <<<<<<<

I think this needs to be the other way around:

=C2=A0 =C2=A0grant dd_admin to dd_owner with admin option;

Best,

Wolfgang

Probably, intend to get those reversed and wasn't in a positi= on to experiment.=C2=A0 In any case fixing the with admin error is the corr= ect approach.

David J.
--000000000000d120910621dce7ba--