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 1sMA7r-000tWD-66 for pgsql-sql@arkaria.postgresql.org; Tue, 25 Jun 2024 17:38:39 +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 1sMA7p-00HAzS-FZ for pgsql-sql@arkaria.postgresql.org; Tue, 25 Jun 2024 17:38:37 +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 1sMA7p-00HAzJ-6s for pgsql-sql@lists.postgresql.org; Tue, 25 Jun 2024 17:38:37 +0000 Received: from mail.nepustil.net ([2001:14f8:1:1::8]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMA7n-003WJ2-El for pgsql-sql@lists.postgresql.org; Tue, 25 Jun 2024 17:38:36 +0000 Received: from [2001:14f8:21c:10::124] (port=57060 helo=axels-imac.in.chaos1.de) by mail.nepustil.net with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.95 (FreeBSD)) (envelope-from ) id 1sMA6M-000P7L-6k; Tue, 25 Jun 2024 19:38:31 +0200 From: Axel Rau Message-Id: <5436D737-391B-4912-82B9-8E479B0A36AE@Chaos1.DE> Content-Type: multipart/alternative; boundary="Apple-Mail=_E1DD2E5F-DC7A-4085-A96C-A7B960DEDD28" Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: struggling with GRANT while upgrading from 13 to 16 Date: Tue, 25 Jun 2024 19:38:33 +0200 In-Reply-To: Cc: pgsql-sql@lists.postgresql.org To: Steve Midgley References: X-Mailer: Apple Mail (2.3608.120.23.2.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_E1DD2E5F-DC7A-4085-A96C-A7B960DEDD28 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Steve. > Am 25.06.2024 um 19:28 schrieb Steve Midgley : >=20 > Is there a reason you can't grant axel those other roles as admin? = Such as: >=20 > GRANT daemons TO axel WITH ADMIN OPTION; > GRANT xtrole TO axel WITH ADMIN OPTION;=20 No this worked. (-: I do another dump and try to load it. Thanks a lot, Axel --- PGP-Key: CDE74120 =E2=98=80 mobile: +49 160 7568212 computing @ chaos claudius --Apple-Mail=_E1DD2E5F-DC7A-4085-A96C-A7B960DEDD28 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Hi = Steve.

Am 25.06.2024 um 19:28 schrieb Steve Midgley = <science@misuse.org>:

Is = there a reason you can't grant axel those other roles as admin? Such = as:

GRANT daemons TO axel WITH ADMIN OPTION;
GRANT xtrole TO axel WITH ADMIN = OPTION; 
No this worked. (-:
I do another dump and try to load it.

Thanks a lot,
Axel
---
PGP-Key: CDE74120 =  =E2=98=80 mobile: +49 160 7568212
computing @ = chaos claudius

= --Apple-Mail=_E1DD2E5F-DC7A-4085-A96C-A7B960DEDD28--