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-general-owner+archive@lists.postgresql.org>)
	id 1soSqQ-00BSW7-I9
	for pgsql-general@arkaria.postgresql.org; Wed, 11 Sep 2024 19:17:40 +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-general-owner+archive@lists.postgresql.org>)
	id 1soSqQ-006KEB-19
	for pgsql-general@arkaria.postgresql.org; Wed, 11 Sep 2024 19:17:38 +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 <walther@technowledgy.de>)
	id 1soSqP-006KDt-H8
	for pgsql-general@lists.postgresql.org; Wed, 11 Sep 2024 19:17:37 +0000
Received: from dd25110.kasserver.com ([85.13.146.49])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <walther@technowledgy.de>)
	id 1soSqI-000gHa-7U
	for pgsql-general@lists.postgresql.org; Wed, 11 Sep 2024 19:17:36 +0000
Received: from [192.168.0.102] (ip-037-201-153-175.um10.pools.vodafone-ip.de [37.201.153.175])
	by dd25110.kasserver.com (Postfix) with ESMTPSA id 7B2CAE1A01AF;
	Wed, 11 Sep 2024 21:17:26 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=technowledgy.de;
	s=kas202308201259; t=1726082246;
	bh=HZ1sA8iJWS6mR1Gzy3UQSLogyObZ62pbEzFPrjmBtmk=;
	h=Date:From:Subject:To:Cc:References:In-Reply-To:From;
	b=DdYC9QoZuaqGYt3MSq678y+TMKgOzLiNf+rh/ywyWKFQHLzoUXsqWGQ8/Y3M3asmz
	 f3rpW78t+aUlukXOU6vWs0jUaJh8r1o0uK8vcctO0BoLRt/v02U8DFHeCUlS6wKgP/
	 tnAsdlGOwO5kL+KVEGrVeH7+0y0bP85uqlH/llfRMgj+ggPJ7kZJwGly/pwXtq9EFR
	 gTaulnNDuDJQ9Uagt/x0fQfZbmHGzHn+Vas/N/u97otfG1lYqCp3SL+9BWz+mniLS4
	 G1Wwp+xAT7kdENMO1FS7C3e6Xq7iIazKAwF5YS6XLUsMpn1RVZu1gMOP1/RtGxZc+7
	 IQs7B2IHZvqrA==
Message-ID: <c42d9931-1ec3-4f41-8b4c-a30f5f79e77d@technowledgy.de>
Date: Wed, 11 Sep 2024 21:17:24 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
From: Wolfgang Walther <walther@technowledgy.de>
Subject: Re: Backward compat issue with v16 around ROLEs
To: Dominique Devienne <ddevienne@gmail.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAFCRh-8+PGGTuqg=rSKA533D0dqYAgq69UzSqMm67VEW02nZyQ@mail.gmail.com>
 <CAKFQuwYK2Vdnbdaxh9QF_0PYpztg51nc-iqYeiKDfpzek7hTdQ@mail.gmail.com>
 <CAFCRh-8ttK7AexZtZq-vcj+u5e2F93HEs63jrkEH0pq6Gf1TWw@mail.gmail.com>
Content-Language: en-US
In-Reply-To: <CAFCRh-8ttK7AexZtZq-vcj+u5e2F93HEs63jrkEH0pq6Gf1TWw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Spamd-Bar: /
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/c42d9931-1ec3-4f41-8b4c-a30f5f79e77d%40technowledgy.de>
Precedence: bulk

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