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 1tISAe-00ER1a-E9 for pgsql-bugs@arkaria.postgresql.org; Tue, 03 Dec 2024 12:38:29 +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 1tISAb-009btj-QO for pgsql-bugs@arkaria.postgresql.org; Tue, 03 Dec 2024 12:38:27 +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 1tIS8x-009ZVM-Gh for pgsql-bugs@lists.postgresql.org; Tue, 03 Dec 2024 12:36:44 +0000 Received: from rex-mailout.bayern.de ([193.34.207.154]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tIS8u-000p9r-HJ for pgsql-bugs@lists.postgresql.org; Tue, 03 Dec 2024 12:36:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1733229400; x=1748781400; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=srUU6ZHEqTtann6cuXpcYTRp4ll4ZC90xvt+hoqMyv4=; b=fRTN1Z8wNJNsA/8BmbqWTreNprnFsncK8DtIqKzoOqnr32mZGd4OpSr+ K9Vf9xbcWnNHISRJAygJuZIPAYnR+ICGjBiYh2swXc0vQwK778fM6WKpV nh+NaAMnxkpQs20duqbddjd29TKEVUjbAA0ZlwJ4IBHi5g2jTQGt5C+BA lENKMts5LMPdtEr+ynGuv2sTE7QzEL7FvRHsqVdrpNgF8NR8EI1K2KC5D 27fTS5ZUA+IJzsAZNOI4RvZks4yLiFPLzYRNE6v4q7FPYuMhssEgJ7C/T /JhYlOpXlFjRRMwDNu4CIRYBtXViLEhEr9rlFDzbHxzgI69cK+KqoT//1 w==; X-CSE-ConnectionGUID: KHMin3YbQvuHCWCio0igGA== X-CSE-MsgGUID: kKZEN0FlR7myYUp9O+6x8Q== Received: from unknown (HELO rin130.bayern.de) ([10.197.20.130]) by rex136.bayern.de with ESMTP; 03 Dec 2024 13:36:35 +0100 X-CSE-ConnectionGUID: 6ADaB+qoSMO90ZuQKcYiuQ== X-CSE-MsgGUID: 0bIXBUiyQxeg+Qj4XaRGBA== X-Talos-CUID: 9a23:P5zL3G1YsD5Dc8rUCwoxiLxfROkJe1ee1XDrBmjpUVR0cZ6eeF6NwfYx X-Talos-MUID: =?us-ascii?q?9a23=3AEYurRw3IkulztRx44AIKhx/23DUju66POGowkIQ?= =?us-ascii?q?/q8SLdhVyZweUthuda9py?= X-BYBN-routing: post Received: from zmx-eg2-p24385.max.bayern.de ([10.173.241.194]) by rin130.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 03 Dec 2024 13:36:26 +0100 Received: from ZMX-EG2-P24385.max.bayern.de (10.173.241.194) by ZMX-EG2-P24385.max.bayern.de (10.173.241.194) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11; Tue, 3 Dec 2024 13:36:25 +0100 Received: from ZMX-EG2-P24385.max.bayern.de ([10.171.65.29]) by ZMX-EG2-P24385.max.bayern.de ([10.171.65.29]) with mapi id 15.02.1544.011; Tue, 3 Dec 2024 13:36:25 +0100 From: "PostgreSQL TDBA (LDBV)" To: Tom Lane CC: "pgsql-bugs@lists.postgresql.org" , "PostgreSQL TDBA (LDBV)" Subject: AW: BUG #18725: "set role" requires "grant connect on database" Thread-Topic: BUG #18725: "set role" requires "grant connect on database" Thread-Index: AQHbQOMR3PQoCtDIa0yBxvaap0VCf7LLXOMAgAkf53A= Date: Tue, 3 Dec 2024 12:36:25 +0000 Message-ID: References: <18725-9fd2f5084a8129ad@postgresql.org> <1895477.1732731060@sss.pgh.pa.us> In-Reply-To: <1895477.1732731060@sss.pgh.pa.us> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.171.65.1] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbmsgeW91IHZlcnkgbXVjaCBmb3IgeW91ciBlZmZvcnQuIA0KTm93IEkgaGF2ZSBtb3JlIGRl dGFpbHMgKEknbSBub3QgYSBkZXZlbG9wZXIpLiAgICAgICAgICcNClRoZSBwcm9ibGVtIG9ubHkg b2NjdXJzIHdpdGggcXVlcmllcyBvbiBsYXJnZSB0YWJsZXMgdGhhdCBydW4gcGFyYWxsZWw6DQoN Cg0KUHJlcGFyYXRpb246DQogICAgW0xvZ2luIHN1cGVydXNlcl0NCiAgICBDUkVBVEUgUk9MRSAi ZmRiYS1Hcm91cCIgV0lUSCBOT0xPR0lOIE5PU1VQRVJVU0VSIElOSEVSSVQgTk9DUkVBVEVEQiBO T0NSRUFURVJPTEUgTk9SRVBMSUNBVElPTiBOT0JZUEFTU1JMUzsNCiAgICBHUkFOVCBDT05ORUNU IE9OIERBVEFCQVNFICJEQVRBQkFTRTEiIFRPICJmZGJhLUdyb3VwIjsNCiAgICBDUkVBVEUgUk9M RSB1c2VyMSBXSVRIIExPR0lOIE5PU1VQRVJVU0VSIElOSEVSSVQgTk9DUkVBVEVEQiBOT0NSRUFU RVJPTEUgTk9SRVBMSUNBVElPTiBOT0JZUEFTU1JMUyBQQVNTV09SRCAndXNlcjEnOw0KICAgIENS RUFURSBST0xFICJzY2hlbWExX293bmVyIiBXSVRIIE5PTE9HSU4gTk9TVVBFUlVTRVIgSU5IRVJJ VCBOT0NSRUFURURCIE5PQ1JFQVRFUk9MRSBOT1JFUExJQ0FUSU9OIE5PQllQQVNTUkxTOyAtLSBv aG5lIExvZ2luLCBvaG5lIENvbm5lY3QtUmVjaHQNCiAgICBHUkFOVCAiZmRiYS1Hcm91cCIsICJz Y2hlbWExX293bmVyIiBUTyB1c2VyMTsNCiAgICBDUkVBVEUgU0NIRU1BIHNjaGVtYTEgQVVUSE9S SVpBVElPTiBzY2hlbWExX293bmVyOw0KICAgIEdSQU5UIEFMTCBPTiBTQ0hFTUEgc2NoZW1hMSBU TyBzY2hlbWExX293bmVyOw0KICAgIENSRUFURSBUQUJMRSBzY2hlbWExLnRhYmxlMSAoY29sdW1u MSBJTlQsIGNvbHVtbjIgVkFSQ0hBUig1MCkpOw0KICAgIEFMVEVSIFRBQkxFIHNjaGVtYTEudGFi bGUxIE9XTkVSIHRvIHNjaGVtYTFfb3duZXI7DQogICAgR1JBTlQgQUxMIE9OIFRBQkxFIHNjaGVt YTEudGFibGUxIFRPIHNjaGVtYTFfb3duZXI7DQogICAgSU5TRVJUIElOVE8gc2NoZW1hMS50YWJs ZTEgKGNvbHVtbjEsIGNvbHVtbjIpIFZBTFVFUyAoMSwgJ2FiYycpLCAoMiwgJ2RlZicpOyAgICAg IA0KDQoNCkltcGxlbWVudGF0aW9uIFZlcnNpb24gPD0gMTYuNCBpcyBPSzoNCiAgICBbTG9naW4g dXNlcjFdDQogICAgU0VUIFJPTEUgc2NoZW1hMV9vd25lcjsNCiAgICAgICAgU0VUDQogICAgc2V0 IGRlYnVnX3BhcmFsbGVsX3F1ZXJ5ID0gb2ZmOw0KICAgICAgICBTRVQNCiAgICBzZWxlY3QgY29s dW1uMSBmcm9tIHNjaGVtYTEudGFibGUxOw0KICAgICAgICAxDQogICAgICAgIDINCiAgICBzZXQg ZGVidWdfcGFyYWxsZWxfcXVlcnkgPSBvbjsNCiAgICAgICAgU0VUDQogICAgc2VsZWN0IGNvbHVt bjEgZnJvbSBzY2hlbWExLnRhYmxlMTsNCiAgICAgICAgMQ0KICAgICAgICAyDQogICAgUkVTRVQg Uk9MRTsNCiAgICAgICAgUkVTRVQNCg0KDQpJbXBsZW1lbnRhdGlvbiBWZXJzaW9uIDE2LjUsIDE2 LjY6DQogICAgW0xvZ2luIHVzZXIxXQ0KICAgIFNFVCBST0xFIHNjaGVtYTFfb3duZXI7DQogICAg ICAgIFNFVA0KICAgIHNldCBkZWJ1Z19wYXJhbGxlbF9xdWVyeSA9IG9mZjsNCiAgICAgICAgU0VU DQogICAgc2VsZWN0IGNvbHVtbjEgZnJvbSBzY2hlbWExLnRhYmxlMTsNCiAgICAgICAgMQ0KICAg ICAgICAyDQogICAgc2V0IGRlYnVnX3BhcmFsbGVsX3F1ZXJ5ID0gb247DQogICAgICAgIFNFVA0K ICAgIHNlbGVjdCBjb2x1bW4xIGZyb20gc2NoZW1hMS50YWJsZTE7DQogICAgICAgIEVSUk9SOiAg QmVudXR6ZXIgaGF0IGRhcyBDT05ORUNULVByaXZpbGVnIG5pY2h0LmtlaW5lIEJlcmVjaHRpZ3Vu ZyBmw7xyIERhdGVuYmFuayDCu0RBVEFCQVNFMcKrIA0KICAgICAgICBGRUhMRVI6ICBrZWluZSBC ZXJlY2h0aWd1bmcgZsO8ciBEYXRlbmJhbmsgwrtEQVRBQkFTRTHCqw0KICAgICAgICBTUUwgc3Rh dGU6IDQyNTAxDQogICAgICAgIERldGFpbDogQmVudXR6ZXIgaGF0IGRhcyBDT05ORUNULVByaXZp bGVnIG5pY2h0Lg0KICAgICAgICBDb250ZXh0OiBwYXJhbGxlbGVyIEFyYmVpdHNwcm96ZXNzDQog ICAgUkVTRVQgUk9MRTsNCiAgICAgICAgUkVTRVQNCg0KDQooV2UgbWFuYWdlIDU1MCBkYXRhYmFz ZXMuIFRocmVlIGN1c3RvbWVycyBoYXZlIGFscmVhZHkgY29udGFjdGVkIHVzIA0KYmVjYXVzZSB0 aGV5IHJlY2VpdmVkIGFuIGVycm9yIG1lc3NhZ2UuIE91ciB3b3JrYXJvdW5kIGlzICJncmFudCBj b25uZWN0Ii4pDQoNCktpbmQgcmVnYXJkcyBTdXNhbm5lIEJpcm5lcg0KDQoNCg0KLS0tLS1VcnNw csO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEu dXM+IA0KR2VzZW5kZXQ6IE1pdHR3b2NoLCAyNy4gTm92ZW1iZXIgMjAyNCAxOToxMQ0KQW46IFBv c3RncmVTUUwgVERCQSAoTERCVikgPFBvc3RncmVTUUxfVERCQUBsZGJ2LmJheWVybi5kZT4NCkNj OiBwZ3NxbC1idWdzQGxpc3RzLnBvc3RncmVzcWwub3JnDQpCZXRyZWZmOiBSZTogQlVHICMxODcy NTogInNldCByb2xlIiByZXF1aXJlcyAiZ3JhbnQgY29ubmVjdCBvbiBkYXRhYmFzZSINCg0KUEcg QnVnIHJlcG9ydGluZyBmb3JtIDxub3JlcGx5QHBvc3RncmVzcWwub3JnPiB3cml0ZXM6DQo+IEFm dGVyIG1pbm9yIHJlbGVhc2UgdXBkYXRlIHRvIHZlcnNpb24gMTYuNSBvciAxNi42ICJzZXQgcm9s ZSIgdG8gcm9sZSANCj4gd2l0aG91dCAiZ3JhbnQgY29ubmVjdCBvbiBkYXRhYmFzZSIgZ2VuZXJh dGVzIGVycm9yOg0KDQo+ICJFUlJPUjogIEJlbnV0emVyIGhhdCBkYXMgQ09OTkVDVC1Qcml2aWxl ZyBuaWNodC5rZWluZSBCZXJlY2h0aWd1bmcgDQo+IGbDvHIgRGF0ZW5iYW5rIMK7Li4uwqsNCj4g RkVITEVSOiAga2VpbmUgQmVyZWNodGlndW5nIGbDvHIgRGF0ZW5iYW5rIMK7Li4uwqsgU1FMIHN0 YXRlOiA0MjUwMQ0KPiBEZXRhaWw6IEJlbnV0emVyIGhhdCBkYXMgQ09OTkVDVC1Qcml2aWxlZyBu aWNodC4NCj4gQ29udGV4dDogcGFyYWxsZWxlciBBcmJlaXRzcHJvemVzcyINCg0KVGhpcyBidWcg cmVwb3J0IGlzIG5vdCBhY3Rpb25hYmxlLCBiZWNhdXNlIHlvdSBkaWRuJ3Qgc2hvdyB3aGF0IHlv dSBkaWQgdG8gcHJvdm9rZSB0aGUgZXJyb3IuICBJIGRpZCBhIGxpdHRsZSBiaXQgb2YgdGVzdGlu ZyBieSBndWVzc2luZyB3aGF0IHlvdSBtaWdodCBiZSB0YWxraW5nIGFib3V0LCBhbmQgSSBkb24n dCBzZWUgYSBwcm9ibGVtOg0KDQpyZWdyZXNzaW9uPSMgY3JlYXRlIHJvbGUgcjsNCkNSRUFURSBS T0xFDQpyZWdyZXNzaW9uPSMgY3JlYXRlIGRhdGFiYXNlIGQ7DQpDUkVBVEUgREFUQUJBU0UNCnJl Z3Jlc3Npb249IyByZXZva2UgY29ubmVjdCBvbiBkYXRhYmFzZSBkIGZyb20gcHVibGljOyBSRVZP S0UgcmVncmVzc2lvbj0jIFxjIGQgWW91IGFyZSBub3cgY29ubmVjdGVkIHRvIGRhdGFiYXNlICJk IiBhcyB1c2VyICJwb3N0Z3JlcyIuDQpkPSMgc2V0IHJvbGUgcjsgICAgICAgICAgICAgICAgLS0g c2hvdWxkIHdvcmssIGFuZCBkb2VzDQpTRVQNCmQ9PiByZXNldCByb2xlOw0KUkVTRVQNCmQ9IyBj cmVhdGUgdXNlciBqb2U7DQpDUkVBVEUgUk9MRQ0KZD0jIGdyYW50IHIgdG8gam9lOw0KR1JBTlQg Uk9MRQ0KZD0jIGFsdGVyIHVzZXIgam9lIHNldCByb2xlID0gcjsNCkFMVEVSIFJPTEUNCmQ9IyBc YyBkIGpvZSAgICAgICAgICAgICAgICAgICAtLSBzaG91bGQgZmFpbCwgYW5kIGRvZXMNCmNvbm5l Y3Rpb24gdG8gc2VydmVyIG9uIHNvY2tldCAiL3RtcC8ucy5QR1NRTC41NDMyIiBmYWlsZWQ6IEZB VEFMOiAgcGVybWlzc2lvbiBkZW5pZWQgZm9yIGRhdGFiYXNlICJkIg0KREVUQUlMOiAgVXNlciBk b2VzIG5vdCBoYXZlIENPTk5FQ1QgcHJpdmlsZWdlLg0KUHJldmlvdXMgY29ubmVjdGlvbiBrZXB0 DQpkPSMgZ3JhbnQgY29ubmVjdCBvbiBkYXRhYmFzZSBkIHRvIGpvZTsNCkdSQU5UDQpkPSMgXGMg ZCBqb2UgICAgICAgICAgICAgICAgICAgLS0gbm93IGl0IHNob3VsZCB3b3JrLCBhbmQgZG9lcw0K WW91IGFyZSBub3cgY29ubmVjdGVkIHRvIGRhdGFiYXNlICJkIiBhcyB1c2VyICJqb2UiLg0KZD0+ IHNob3cgcm9sZTsNCiByb2xlDQotLS0tLS0NCiByDQooMSByb3cpDQoNClBsZWFzZSBwcm92aWRl IGEgc2VsZi1jb250YWluZWQgc2NyaXB0IHRoYXQgcmVwcm9kdWNlcyB5b3VyIHByb2JsZW0uDQoN CgkJCXJlZ2FyZHMsIHRvbSBsYW5lDQo=