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.98.2) (envelope-from ) id 1xHHux-00000002vMh-0e2Q for pgsql-general@arkaria.postgresql.org; Thu, 15 Oct 2026 09:38:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xHHuu-000000087vU-0k2E for pgsql-general@arkaria.postgresql.org; Thu, 15 Oct 2026 09:38:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xHHsa-00000007zsT-0Sc4 for pgsql-general@lists.postgresql.org; Thu, 15 Oct 2026 09:36:04 +0000 Received: from rex-mailout.bayern.de ([193.34.207.154]) by makus.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xHHsW-000000027zU-0nmU for pgsql-general@postgresql.org; Thu, 15 Oct 2026 09:36:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1792056960; x=1807608960; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=anly5z791cD0niRSrBZqw6EwbqkqJfbIBExd8XYH+L4=; b=KM432PYQHGu/RvtUeLCO7w7Mjcy/UAOU4992frqs1ZZWp9m8oKAhhPec Etf+7kmo0fMULpft+IivkGpV/shwzKp/oxbGRchl8VZ3ZRYXp8rbfYYxh +SiBmv5P8lLwDvB734kaxsd34qHblA4B8tTBeK6zxmV49qDCEO942gAav QtKfZ6ShJm8083Rw69DphuC6rG+7wAllc5aeZXz79F1iUF8E94KCi2cXe 47uTxgVCFjo04IM5NE0rY1O39gP0lvlMsvYziF7R6Ekcw8qI43i+BUgWZ mVDNh1woNoRg3goPx5G5+du7Lupqo57rZrlLfNQiyd0zv1+74SIfazse9 g==; X-CSE-ConnectionGUID: 1F/8LoEERp2WuPrychWtBQ== X-CSE-MsgGUID: 14/8CZ9KStq3Pg+Ek2D2Sg== Received: from unknown (HELO rin140.bayern.de) ([10.197.20.140]) by rex146.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 15 Oct 2026 11:35:57 +0200 X-CSE-ConnectionGUID: rdniB01RR/+JkPB9w5vkZw== X-CSE-MsgGUID: /RAI1o8pQZezmTC1NaXUyQ== X-Talos-CUID: 9a23:yfjKom7NzjmVJ81jrdss7kISG+p9K0fnizTyIHeSWHk0Vr6nVgrF X-Talos-MUID: =?us-ascii?q?9a23=3ANjmVNwy3fNTX4F4rFUeRCuvDFz6aqOOUIWFUlsU?= =?us-ascii?q?egvuJJylMEG67hQSKU7Zyfw=3D=3D?= X-BYBN-routing: post Received: from zmx-ed1-p24372.max.bayern.de ([10.173.241.233]) by rin140.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 15 Oct 2026 11:35:56 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de (10.173.241.200) by ZMX-ED1-P24372.max.bayern.de (10.173.241.233) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.2562.49; Thu, 15 Oct 2026 11:35:56 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de ([10.173.241.200]) by ZMX-EJ2-P25850.max.bayern.de ([10.173.241.200]) with mapi id 15.02.2562.049; Thu, 15 Oct 2026 11:35:56 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Laurenz Albe , "pgsql-general@postgresql.org" CC: "Haupt, Matthias (StMUK)" , Adrian Klaver Subject: AW: AW: AW: Why is materialized view creation a "security-restricted operation"? Thread-Topic: AW: AW: Why is materialized view creation a "security-restricted operation"? Thread-Index: AQHdUeFL0Utg7jYUl0GDhsYiKoFwtrb5rX5QgAGS4oCAACfpcIAABUEAgAAkV6CAAPIagIAB4KuQ Date: Thu, 15 Oct 2026 09:35:56 +0000 Message-ID: <765e653e734f4bf991e148eb57197931@stmuk.bayern.de> References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <2e9d29c1513afb47d652387ea5299076ef24adce.camel@cybertec.at> <4d7467aa0ee958343fca8c6bd6720952b5bc08b1.camel@cybertec.at> <5628a96712e14b9fac594b34b0eb9161@stmuk.bayern.de> <3b50a3393fd84d56b40cfddd67c98dbc@stmuk.bayern.de> <514c6166ffe28f5007e55d3829a822c7de27c45a.camel@cybertec.at> In-Reply-To: <514c6166ffe28f5007e55d3829a822c7de27c45a.camel@cybertec.at> 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 PiBJZiB5b3Ugd2FudCB0byBoZWFyIG15IG9waW5pb24gb2Ygd2hhdCB0aGUgcHJvYmxlbSB1bmRl cmx5aW5nIHRoZSBhbm5veWluZyBsaW1pdGF0aW9uIHlvdSBhcmUgaGl0dGluZyBpczogaXQgaXMg UG9zdGdyZVNRTCdzICJzZWFyY2hfcGF0aCIgcGFyYW1ldGVyLiANClllcywgb25lIGNhbiBmcmFt ZSBpdCBsaWtlIHRoYXQuIEFuZCAncGdfdGVtcCcgYmVpbmcgaW4gZnJvbnQsIGFuZCBpbiB0aGUg Y29uc2VxdWVuY2UsIHRoZSBNQVQgVklFVyByZWZyZXNoIHNlY3VyaXR5IGxpbWl0YXRpb24uDQoN Cj4gVGhhdCdzIHdoeSB5b3UgdGVzdCB0aGUgZnVuY3Rpb25hbGl0eSBvZiB5b3VyIGFwcGxpY2F0 aW9uIGFoZWFkIG9mIHRpbWUsIHJpZ2h0Pw0KWWVzLiBJbiB0aGlzIGNhc2UsIGl0IHdhcyBhIENI QU5HRSB3aGljaCBub3cgYWZmZWN0cyB0aGUgTUFUVklFVywgYW5kIGl0IGxvb2tzIGxpa2UgSSBu b3cgaGF2ZSB0byByZXBsYWNlIHRoZSBNQVRWSUVXICh3aGljaCBhbHJlYWR5IGV4aXN0ZWQgZm9y IHNvbWUgdGltZSkgd2l0aCBhIEZVTkNUSU9OLCB3aGljaCBoYXMgYWRkaXRpb25hbCBjb25zZXF1 ZW5jZXMgKG1vZGlmaW5nIGV2ZXJ5IGNhbGxpbmcgcG9pbnQgb2YgdGhhdCBNQVRWSUVXIHRvIG5v dyBjYWxsIGEgRlVOQ1RJT04pLg0KDQo+IEkgdW5kZXJzdGFuZCB5b3VyIHVuZWFzZSB3aXRoIHRo ZSBzaXR1YXRpb24sIGJ1dCBJIGFtIHN1cnByaXNlZCBieSB5b3VyIHN0dWJib3JubmVzcy4NCj4g VGhlcmUgYXJlIGxpbWl0YXRpb25zIHdpdGggZXZlcnkgYXJjaGl0ZWN0dXJlLiAgWW91IGp1c3Qg aGl0IG9uZSBpbiBQb3N0Z3JlU1FMLg0KPiBXb3JrIGFyb3VuZCBpdCBhbmQgbW92ZSBvbi4NClll cy4NCkkgY2FuIHdvcmsgYXJvdW5kIGFuZCBtb3ZlIG9uLg0KSXQgd2FzIHN1cnByaXNpbmcgaG93 IG1hbnkgb2JzdGFjbGVzIHRoZXJlIGFyZSBpbiBteSB3YXkuDQpJIHByZXZpb3VzbHkgd2FudGVk IHRvIHBvaW50IG91dCB0aGF0IGl0IG5lZWRuJ3QgYmUgdGhhdCBsaW1pdGVkLCBlc3BlY2lhbGx5 IGF0IGxhc3QgdGhlICJDT1BZIC4uLiBGUk9NIC4uLiAiIGxpbWl0YXRpb24gdGhhdCBhIHRhYmxl IGlzIG5lZWRlZCAoRHVja0RCIGRvZXNuJ3QgaGF2ZSB0aGF0KS4NCg0KSSB3aWxsIGV4cGxvcmUg dGhlIHBvc3NpYmlsaXR5IG9mIGEgbm9uLXRlbXAgVEFCTEUgaGVyZSBidXQgd2FzIGEgYml0IGFm cmFpZCBhYm91dCBjb25jdXJyZW5jeSBpc3N1ZXMgb24gY29uY3VycmVudCBleGVjdXRpb24gb2Yg Q1JFQVRJTkcvRFJPUFBJTkcvVFJVTkNBVElORyB0aGF0IHRhYmxlLCBhcyB0YWxrZWQgYWJvdXQg aW4gdGhlIGNvbmN1cnJlbnQgW3B1biBpbnRlbmRlZF0gZGlzY3Vzc2lvbiB3aXRoIEFkcmlhbi4N Cg0KDQpUaGFuayBZb3UuDQoNCg0KUmVnYXJkcywNCkZyYW56LUpvc2VmIEbDpHJiZXINCg0KLS0t LS1VcnNwcsO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBMYXVyZW56IEFsYmUgPGxhdXJl bnouYWxiZUBjeWJlcnRlYy5hdD4gDQpHZXNlbmRldDogTWl0dHdvY2gsIDE0LiBPa3RvYmVyIDIw MjYgMDg6MjQNCkFuOiBGw6RyYmVyLCBGcmFuei1Kb3NlZiAoU3RNVUspIDxGcmFuei1Kb3NlZi5G YWVyYmVyQHN0bXVrLmJheWVybi5kZT47IEFkcmlhbiBLbGF2ZXIgPGFkcmlhbi5rbGF2ZXJAYWts YXZlci5jb20+OyBwZ3NxbC1nZW5lcmFsQHBvc3RncmVzcWwub3JnDQpDYzogSGF1cHQsIE1hdHRo aWFzIChTdE1VSykgPE1hdHRoaWFzLkhhdXB0QHN0bXVrLmJheWVybi5kZT4NCkJldHJlZmY6IFJl OiBBVzogQVc6IFdoeSBpcyBtYXRlcmlhbGl6ZWQgdmlldyBjcmVhdGlvbiBhICJzZWN1cml0eS1y ZXN0cmljdGVkIG9wZXJhdGlvbiI/DQoNCk9uIFR1ZSwgMjAyNi0xMC0xMyBhdCAxNDoxNyArMDAw MCwgRsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKSB3cm90ZToNCj4gPiBXZWxsLCB5b3Ugd2Fu dCB0byB1c2UgYSBtYXRlcmlhbGl6ZWQgdmlldyBmb3Igc29tZXRoaW5nIHRoYXQgaXQgDQo+ID4g Y2Fubm90IGJlIHVzZWQgZm9yLCBmb3Igc2VjdXJpdHkgcmVhc29ucy4gIFdlIHRyaWVkIHRvIGV4 cGxhaW4gdGhhdCBpbiB0aGlzIHRocmVhZC4NCj4NCj4gWWVzLCB5b3UgY2FuIHNlZSBpdCB0aGlz IHdheTogT25lIHdheSB3b3VsZCBiZTogVXNpbmcgVGVtcCBUYWJsZXMuIA0KPiBUaGlzIHdheSBp cyBibG9ja2VkIGR1ZSB0byBzZWN1cml0eSByZWFzb25zLiBEaXNjdXNzaW9uIGZpbmlzaGVkLg0K PiANCj4gQW5vdGhlciBwb2ludCBvZiB2aWV3IGlzOg0KPiAwKSBUaGUgc2VjdXJpdHkgcHJvYmxl bSBpcyBub3QgaW5oZXJlbnQgZm9yIHdoYXQgSSB3YXMgdHJ5aW5nIHRvIGFyY2hpZXZlOyBidXQg ZHVlIHRvDQo+ICAgIGxhY2sgb2YgZXhwcmVzc2l2ZW5lc3Mgb25lIGlzIGZvcmNlZCBpbnRvIHRo aXMgZGVhZCBlbmQuDQo+IDEpIEVpdGhlcjogUG9zdGdyZXMnIENPUFkgc3RtdCBsYWNrcyB0aGUg YWJpbGl0eSB0byBvbWl0IHRoZSBwaHlzaWNhbCB0YWJsZSwgc29tZXRoaW5nDQo+ICAgIGxpa2Ug U0VMRUNUICogRlJPTSBDT1BZIEZST00gLi4uDQo+IDIpIG9yOiBQb3N0Z3JlcyBsYWNrcyB0YWJs ZSB2YXJpYWJsZXMuDQoNClBvaW50IDAgaXMgaW5jb21wcmVoZW5zaWJsZSB0byBteSBsaW1pdGVk IGJyYWluLiAgUG9pbnQgMSBpcyBhIG1pc3NpbmcgZmVhdHVyZS4NClBvaW50IDIgaXMgZWFzaWx5 IHNvbHZlZCB3aXRoIGFycmF5IHZhcmlhYmxlcywgd2hpY2ggYXJndWFibHkgYXJlIHByZXR0eSBt dWNoIHRoYXQuDQoNCkkgdW5kZXJzdGFuZCB5b3VyIHVuZWFzZSB3aXRoIHRoZSBzaXR1YXRpb24s IGJ1dCBJIGFtIHN1cnByaXNlZCBieSB5b3VyIHN0dWJib3JubmVzcy4NClRoZXJlIGFyZSBsaW1p dGF0aW9ucyB3aXRoIGV2ZXJ5IGFyY2hpdGVjdHVyZS4gIFlvdSBqdXN0IGhpdCBvbmUgaW4gUG9z dGdyZVNRTC4NCldvcmsgYXJvdW5kIGl0IGFuZCBtb3ZlIG9uLg0KDQo+ID4gSnVzdCBiZWNhdXNl IHRoZSBmZWF0dXJlcyB5b3UgYXJlIHN0YWNraW5nIGRvbid0IHdvcmsgdGhlIHdheSB5b3UnZCAN Cj4gPiBsaWtlIHRoZW0gdG8sIGl0J3Mgbm90IGEgc2hvcnRjb21pbmcgb2Ygb3J0aG9nb25hbGl0 eSBvciBtb2R1bGFyaXR5Lg0KPg0KPiBXZWxsIHRoaXMgaXMgbXkgdmVyeSBkZWZpbml0aW9uIG9m IG9ydGhvZ29uYWxpdHkgLyBtb2R1bGFyaXR5LCBUaGlzIGlzIHdoYXQgSSdtIG91dCBmb3I6DQo+ IExhbmd1YWdlIGZlYXR1cmVzIHNob3VsZCBiZSBnZW5lcmFsbHkgY29tYmluYWJsZSwgd2l0aCB2 ZXJ5IGZldyBsaW1pdHMuDQoNCk9uZSBvZiB0aGVzZSBsaW1pdHMgYmVpbmcgc2VjdXJpdHkuICBZ b3VyIHNldHVwIGRvZXNuJ3QgY2FyZSBmb3Igc2VjdXJpdHkgY29uc2lkZXJhdGlvbnMuICBUaGF0 J3Mgb2theSwgYnV0IHNlY3VyaXR5IG1pZ2h0IGJlIHJlbGV2YW50IGluIG90aGVyIHNpdHVhdGlv bnMuDQoNCklmIHlvdSB3YW50IHRvIGhlYXIgbXkgb3BpbmlvbiBvZiB3aGF0IHRoZSBwcm9ibGVt IHVuZGVybHlpbmcgdGhlIGFubm95aW5nIGxpbWl0YXRpb24geW91IGFyZSBoaXR0aW5nIGlzOiBp dCBpcyBQb3N0Z3JlU1FMJ3MgInNlYXJjaF9wYXRoIiBwYXJhbWV0ZXIuICBJdCBpcyB2ZXJ5IHBv d2VyZnVsLCBidXQgYnkgdmlydHVlIG9mIHRoYXQgaXQgaGFzIG9wZW5lZCB0aGUgd2F5IHRvIG1h bnkgcHJpdmlsZWdlIGVzY2FsYXRpb24gYXR0YWNrcy4NCkknZCBhc3N1bWUgdGhhdCB3aXRoIHBl cmZlY3QgaGluZHNpZ2h0LCBQb3N0Z3JlU1FMIHdvdWxkIG5ldmVyIGhhdmUgaW50cm9kdWNlZCB0 aGF0IHBhcmFtZXRlci4gIFRoZSBhbm5veWluZyBzZWN1cml0eSByZXN0cmljdGlvbiB5b3UgYXJl IGhpdHRpbmcgaXMgc3VwcG9zZWQgdG8gcHJldmVudCBwcml2aWxlZ2UgZXNjYWxhdGlvbiBhdHRh Y2tzIHdoZW4gYSBzdXBlcnVzZXIgcmVzdG9yZXMgYSBkdW1wIHdpdGggYSBtYWxpY2lvdXNseSBj cmFmdGVkIG1hdGVyaWFsaXplZCB2aWV3IGluIGl0LCBJIGJlbGlldmUuDQoNCj4gPiBZb3UgY291 bGQgd3JpdGUgYSBwcm9jZWR1cmUgdGhhdCB0cnVuY2F0ZXMgdGhlIHRhYmxlIGFuZCBwb3B1bGF0 ZXMgDQo+ID4gaXQgd2l0aCBhIHF1ZXJ5LCB1c2luZyBhIHRlbXBvcmFyeSB0YWJsZSBpZiB5b3Ug d2FudC4gIENhbGxpbmcgdGhhdCANCj4gPiBwcm9jZWR1cmUgaXMganVzdCBhcyBjb252ZW5pZW50 IGFzIGNhbGxpbmcgUkVGUkVTSCBNQVRFUklBTElaRUQgVklFVy4NCj4NCj4gWWVzLCB0aGF0J3Mg d2hhdCBJIG1lYW50IGluIG15IGxhc3QgcG9zdC4NCj4gQnV0IHRoaXMgbGVhZHMgdG86IEkgbmVl ZCB0byBhZGp1c3QgYWxsIGNhbGxpbmdzIHBvaW50cywgbm90aWZ5IHVzZXJzIA0KPiBvZiB0aGUg cHJldmlvdXNseS1NQVRWSUVXIHRvIGFkanVzdCwgYW5kIHNvIG9uLg0KDQpJIHVuZGVyc3RhbmQg dGhhdCB0aGF0IGNhbiBiZSBhbm5veWluZy4gIFRoYXQncyB3aHkgeW91IHRlc3QgdGhlIGZ1bmN0 aW9uYWxpdHkgb2YgeW91ciBhcHBsaWNhdGlvbiBhaGVhZCBvZiB0aW1lLCByaWdodD8NCg0KWW91 cnMsDQpMYXVyZW56IEFsYmUNCg==