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 1xGyql-00000002kaB-2AkL for pgsql-general@arkaria.postgresql.org; Wed, 14 Oct 2026 13:16:56 +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 1xGyqj-00000003Duz-0Y0i for pgsql-general@arkaria.postgresql.org; Wed, 14 Oct 2026 13:16:53 +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 1xGyqi-00000003Duq-2MpE for pgsql-general@lists.postgresql.org; Wed, 14 Oct 2026 13:16:52 +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 1xGyqe-00000001z45-3T72 for pgsql-general@postgresql.org; Wed, 14 Oct 2026 13:16:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791983808; x=1807535808; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=DpDzRlB3uqcgcg8aiz72obFEcnh9xxKHNQ7JYhIpNRA=; b=nXHOlsJ+FFd0A7dVhemzFMLsY6KdHU0hutDheidaqWGeBaLr/UJzUIvz 84h/H+gF3Vn6N1AGpCSiQz6C7Dy9kxdeqXIfD2ismvIx9VicRPcVwuy/y y9X/p6lJQZe21PxUHZfcw83pX3CHo13323VCo5wq61JsTpCsyF257bxqT rVpB3v2WGF9VlbEW5fzeKgBJhcBRfQlfnf9so6fQKd6nk+pmxT9UHpphu O19TNMkdWzsvh6F+IMje7IXLqc5eihb/eVb6/tXtCreCvNd5CgltWeTTQ h3KhCGeVJ7651ecf8a/Bv6kckHVmjOLyb/mKhOxyezk5AKLh6liGlVZja g==; X-CSE-ConnectionGUID: se6wXqmoRZCb6v4eihzw6w== X-CSE-MsgGUID: QddoQzV2QCq/C8sendTLlg== Received: from unknown (HELO rin132.bayern.de) ([10.197.20.132]) by rex136.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 14 Oct 2026 15:16:45 +0200 X-CSE-ConnectionGUID: V0AKCSnZR+OrfbAA1cJWew== X-CSE-MsgGUID: rjwaJj1nQt6DzomndXY5DQ== X-Talos-CUID: 9a23:0M/TTG0fBdBjJnbbwc34NLxfJJgMUVbmykXqYGiiB2xAYeSea2Cd5/Yx X-Talos-MUID: =?us-ascii?q?9a23=3AoM1Z8AwKeShIE8gTsL0T/tEViJqaqL6sF0kvk8w?= =?us-ascii?q?AgtXaGT53PjGRvAXqbrZyfw=3D=3D?= X-BYBN-routing: post Received: from zmx-ed2-p24373.max.bayern.de ([10.173.241.234]) by rin132.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 14 Oct 2026 15:16:44 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de (10.173.241.200) by ZMX-ED2-P24373.max.bayern.de (10.173.241.234) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.2562.49; Wed, 14 Oct 2026 15:16:44 +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; Wed, 14 Oct 2026 15:16:44 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Adrian Klaver , Laurenz Albe , "pgsql-general@postgresql.org" CC: "Haupt, Matthias (StMUK)" Subject: AW: AW: Why is materialized view creation a "security-restricted operation"? Thread-Topic: AW: Why is materialized view creation a "security-restricted operation"? Thread-Index: AQHdUeFL0Utg7jYUl0GDhsYiKoFwtrb5rX5QgAGS4oCAACfpcIAAML6AgAF9ydA= Date: Wed, 14 Oct 2026 13:16:44 +0000 Message-ID: <687d09da725449d18e88654dafd9efdd@stmuk.bayern.de> References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <2e9d29c1513afb47d652387ea5299076ef24adce.camel@cybertec.at> <4d7467aa0ee958343fca8c6bd6720952b5bc08b1.camel@cybertec.at> <5628a96712e14b9fac594b34b0eb9161@stmuk.bayern.de> In-Reply-To: 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 VGhhbmtzIGZvciB0aGUgc3VnZ2VzdGlvbi4gQ291bGQgd29yay4NCg0KKiBUaGVuIHdlIGhhdmUg YSB0YWJsZSBhdCBnbG9iYWwgc2NvcGUuDQoqIEhvd2V2ZXIgaXQgd29uJ3QgYmUgc2VlbiBieSBv dGhlciB0cmFuc2FjdGlvbnMsIGFuZCBpcyBkZWxldGVkIGluIHRoZSBzYW1lIHRyYW5zYWN0aW9u LiBTb3VuZHMgc2FmZSBhdCBmaXJzdCBnbGFuY2U/DQoqIFdlbGwsIHdoYXQgYWJvdXQgdHdvIHRy YW5zYWN0aW9ucyBydW5uaW5nIGNvbmN1cnJlbnRseSwgYm90aCBleGVjdXRpbmcgcHVibGljLnRl bXBfdGFibGUoKT8gSXMgc2FmZSwgdG9vLCBhcyBmYXIgYXMgSSB1bmRlcnN0YW5kIGFib3V0IHRy YW5zYWN0aW9ucz8gRWFjaCB0cmFuc2FjdGlvbiBoYXMgaXRzIG93biB0YWJsZSwgZXZlbiB0aG91 Z2ggb24gZ2xvYmFsIHNjb3BlPw0KDQpRdWl0ZSBhIGJ1bmNoIG9mIHRoaW5ncyB0byBjb25zaWRl ciwgYnV0IHNvdW5kcyBzYWZlIGVub3VnaCBmb3IgbWUuIFRoYW5rIHlvdS4NCg0KDQpSZWdhcmRz LA0KRnJhbnotSm9zZWYgRsOkcmJlcg0KDQotLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0t LS0tDQpWb246IEFkcmlhbiBLbGF2ZXIgPGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+IA0KR2Vz ZW5kZXQ6IERpZW5zdGFnLCAxMy4gT2t0b2JlciAyMDI2IDE4OjIzDQpBbjogRsOkcmJlciwgRnJh bnotSm9zZWYgKFN0TVVLKSA8RnJhbnotSm9zZWYuRmFlcmJlckBzdG11ay5iYXllcm4uZGU+OyBM YXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD47IHBnc3FsLWdlbmVyYWxAcG9z dGdyZXNxbC5vcmcNCkNjOiBIYXVwdCwgTWF0dGhpYXMgKFN0TVVLKSA8TWF0dGhpYXMuSGF1cHRA c3RtdWsuYmF5ZXJuLmRlPg0KQmV0cmVmZjogUmU6IEFXOiBXaHkgaXMgbWF0ZXJpYWxpemVkIHZp ZXcgY3JlYXRpb24gYSAic2VjdXJpdHktcmVzdHJpY3RlZCBvcGVyYXRpb24iPw0KDQpPbiAxMC8x My8yNiA0OjM2IEFNLCBGw6RyYmVyLCBGcmFuei1Kb3NlZiAoU3RNVUspIHdyb3RlOg0KPj4+IFty YW50IGFib3V0IFBvc3RncmVTUUwgc2VjdXJpdHkgcmVzdHJpY3Rpb25zXQ0KPiBObyBubyBubywg bm90IGFib3V0IHNlY3VyaXR5IHJlc3RyaWN0aW9ucy4gVGhlIHJhbnQgaXMgYWJvdXQgbGFja2lu ZyBvcnRob2dvbmFsaXR5LiBBYm91dCBvZnRlbiBOT1QgYmVpbmcgYWJsZSB0byBjb21iaW5lIGxh bmd1YWdlIGZlYXR1cmVzLiBEb2Vzbid0IGFueWJvZHkgc2hhcmUgdGhhdCB2aWV3PyBXZSBDT1VM RCBkbyBiZXR0ZXIsIEkgdGhpbmsuDQoNClF1aWNrIGFuZCBkaXJ0eSBleGFtcGxlLg0KDQpjYXQg dGVzdC5jc3YNCjEsZG9nLHQNCjIsY2F0LGYNCjMsZmlzaCx0DQoNCkNSRUFURSBPUiBSRVBMQUNF IEZVTkNUSU9OIHB1YmxpYy50ZW1wX3RhYmxlKCkNCiAgUkVUVVJOUyBUQUJMRShpZCBpbnRlZ2Vy LCB0eXBlIGNoYXJhY3RlciB2YXJ5aW5nLCBhY3RpdmUgYm9vbGVhbikNCiAgTEFOR1VBR0UgcGxw Z3NxbA0KQVMgJGZ1bmN0aW9uJA0KQkVHSU4NCiAgICAgRFJPUCBUQUJMRSBJRiBFWElTVFMgdGVz dF9jc3Y7DQogICAgIENSRUFURSBUQUJMRSB0ZXN0X2NzdihpZCBpbnRlZ2VyLCB0eXBlIHZhcmNo YXIsIGFjdGl2ZSBib29sZWFuKTsNCiAgICAgQ09QWSB0ZXN0X2NzdiBGUk9NICcvdmFyL2xpYi9w b3N0Z3Jlc3FsLzE4L21haW4vdGVzdC5jc3YnIFdJVEggQ1NWOw0KICAgICBSRVRVUk4gUVVFUlkg RVhFQ1VURQ0KICAgICAgICAgJ1NFTEVDVCBpZCwgdHlwZSwgYWN0aXZlIEZST00gdGVzdF9jc3Yn OyBFTkQ7ICRmdW5jdGlvbiQNCg0KDQpzZWxlY3QgKiBmcm9tIHRlbXBfdGFibGUoKTsNCiAgaWQg fCB0eXBlIHwgYWN0aXZlDQotLS0tKy0tLS0tLSstLS0tLS0tLQ0KICAgMSB8IGRvZyAgfCB0DQog ICAyIHwgY2F0ICB8IGYNCiAgIDMgfCBmaXNoIHwgdA0KDQoNCj4gDQo+PiBJZiB0aGUgc2VjdXJp dHkgcmVzdHJpY3Rpb25zIG9mIG1hdGVyaWFsaXplZCB2aWV3cyBwcmV2ZW50IHlvdSBmcm9tIHVz aW5nIHRoZW0sIHdoeSBkb24ndCB5b3UgdXNlIGEgbm9ybWFsIHRhYmxlIGluc3RlYWQsIFRSVU5D QVRFIGl0IGFuZCBJTlNFUlQgaW50byBpdD8NCj4gVGhlIE1BVCBWSUVXIGlzIHVzZWQgZnJvbSAi b3V0c2lkZSIuIEZyb20gb3RoZXIgdmlld3MsIG9yIGZyb20gYSBjbGllbnQgdGhhdCBjb25uZWN0 cyB0byB0aGUgZGF0YWJhc2UuDQo+IA0KPiAqIEkgY2FuIHJlcGxhY2UgaXQgd2l0aCBhIHZpZXc7 IEkgZGlkbid0IGRvIHRoYXQgZm9yIHBlcmZvcm1hbmNlIHJlYXNvbnMuDQo+ICogSSBjYW4gcmVw bGFjZSBpdCB3aXRoIGEgcGVyc2lzdGVudCB0YWJsZSwgYSBzdG9yZWQgcHJvY2VkdXJlLCBhbmQg Y3VzdG9tIGNhY2hpbmcgbG9naWMuIFRoYXQnbGwgd29yay4gQnV0IHRoaXMgaXMgd2hhdCBhIE1B VCBWSUVXIGlzIGZvciwgSSB0aG91Z2h0Lg0KPiANCj4gDQo+IFJlZ2FyZHMsDQo+IEZyYW56LUpv c2VmIEbDpHJiZXINCj4gDQo+IC0tLS0tVXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0LS0tLS0NCj4g Vm9uOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD4NCj4gR2VzZW5kZXQ6 IERpZW5zdGFnLCAxMy4gT2t0b2JlciAyMDI2IDEzOjA2DQo+IEFuOiBGw6RyYmVyLCBGcmFuei1K b3NlZiAoU3RNVUspIDxGcmFuei1Kb3NlZi5GYWVyYmVyQHN0bXVrLmJheWVybi5kZT47IA0KPiBB ZHJpYW4gS2xhdmVyIDxhZHJpYW4ua2xhdmVyQGFrbGF2ZXIuY29tPjsgDQo+IHBnc3FsLWdlbmVy YWxAcG9zdGdyZXNxbC5vcmcNCj4gQ2M6IEhhdXB0LCBNYXR0aGlhcyAoU3RNVUspIDxNYXR0aGlh cy5IYXVwdEBzdG11ay5iYXllcm4uZGU+DQo+IEJldHJlZmY6IFJlOiBXaHkgaXMgbWF0ZXJpYWxp emVkIHZpZXcgY3JlYXRpb24gYSAic2VjdXJpdHktcmVzdHJpY3RlZCBvcGVyYXRpb24iPw0KPiAN Cj4gT24gTW9uLCAyMDI2LTEwLTEyIGF0IDE0OjU5ICswMDAwLCBGw6RyYmVyLCBGcmFuei1Kb3Nl ZiAoU3RNVUspIHdyb3RlOg0KPiANCj4+IFtyYW50IGFib3V0IFBvc3RncmVTUUwgc2VjdXJpdHkg cmVzdHJpY3Rpb25zXQ0KPj4NCj4+IE9rLCBJIHRoaW5rIHNvbWUgcGVvcGxlIGdldCB0aGUgcG9p bnQgdGhhdCBJIGNsYWltIFNRTCAvIFBvc3RncmVzIGlzIA0KPj4gbGFja2luZyBtb2R1bGFyaXR5 IC8gb3J0aG9nb25hbGl0eSBpbiB0aGUgd2F5IGFzIEkgdHJpZWQgdG8gZGVmaW5lIGFib3ZlLg0K PiANCj4gSSBkb24ndC4gIEp1c3QgYmVjYXVzZSB0aGUgZmVhdHVyZXMgeW91IGFyZSBzdGFja2lu ZyBkb24ndCB3b3JrIHRoZSB3YXkgeW91J2QgbGlrZSB0aGVtIHRvLCBpdCdzIG5vdCBhIHNob3J0 Y29taW5nIG9mIG9ydGhvZ29uYWxpdHkgb3IgbW9kdWxhcml0eS4NCj4gDQo+PiBTbyBsZXQgbWUg ZXhwbGFpbi4gQW5kIHBlcmhhcHMgc29tZWJvZHkgY2FuIGdpdmUgZ29vZCBhZHZpY2UuDQo+Pg0K Pj4gKiBJIGFtIHJ1bm5pbmcgUG9zdGdyZXMgaW4gYSBjb250YWluZXIuDQo+PiAqIEkgYW0gdXNp bmcgaHR0cHM6Ly9naXRodWIuY29tL3ByYW1zZXkvcGdzcWwtaHR0cCB0byBxdWVyeSBSRVNUIHNl cnZpY2VzIHVzaW5nIGNyZWRlbnRpYWxzLg0KPj4gKiBJIHRvb2sgaXQgYXMgZ29vZCBhZHZpY2Ug dG8gcGFzcyBlbnZpcm9ubWVudCB2YXJpYWJsZXMgaW50byB0aGUgY29udGFpbmVyLCBhbmQgdG8g cGFzcw0KPj4gICAgcGFzc3dvcmRzIGFzIHNpbmdsZSBmaWxlcywgaW4gbW91bnRlZCBjb250YWlu ZXIgZGlyZWN0b3J5IC9ydW4vc2VjcmV0cy8gLg0KPj4gKiBJbnNpZGUgcG9zdGdyZXMgSSBhbSB0 cnlpbmcgdG8gbG9hZCB0aGF0IGRhdGEsIHVzaW5nIG1lbW9pemF0aW9uIHBhdHRlcm4uIEZvciBl eGFtcGxlIHVzaW5nDQo+PiAgICBDUkVBVEUgVEVNUCBUQUJMRSB4IC4uLjsgQ09QWSB4IC4uLiBG Uk9NIFBST0dSQU0gJ2NhdCAvcnVuL3NlY3JldHMvbXlwYXNzd29yZCcuDQo+PiAgICBUaGlzIHBh cnQgaXMgZW5jYXBzdWxhdGVkIGFzIGEgZnVuY3Rpb24uDQo+Pg0KPj4gKiBOb3cgdGhlcmUgd2Fz IG9uZSBwb2ludCB3aGVyZSBJIHdhcyB1c2luZyBhIE1BVEVSSUFMSVpFRCBWSUVXIGFjY2Vzc2lu ZyB0aGF0IGZ1bmN0aW9uLg0KPj4gICAgQW5kIHdlbGwsIHRoYXQgZmFpbGVkLg0KPj4NCj4+IFdo YXQgSSBDT1VMRCBkbyBpcyByZXBsYWNlIENPUFkgeCAuLi4gRlJPTSBQUk9HUkFNIHdpdGggYSBm aWxlX2ZkdyANCj4+IEZPUkVJR04gVEFCTEUsIGJ1dCB0aGlzIHdheSBpdCBpc24ndCBwYXJhbWV0 cml6YWJsZS4gSSB3b3VsZCBoYXZlIHRvIA0KPj4gY3JlYXRlIGFzIG1hbnkgZm9yZWlnbiB0YWJs ZXMgYXMgSSBoYXZlIHBhc3N3b3JkcyAvIGVudmlyb25tZW50IHZhcmlhYmxlcywgSSB0aGluay4N Cj4gDQo+IElmIHRoZSBzZWN1cml0eSByZXN0cmljdGlvbnMgb2YgbWF0ZXJpYWxpemVkIHZpZXdz IHByZXZlbnQgeW91IGZyb20gdXNpbmcgdGhlbSwgd2h5IGRvbid0IHlvdSB1c2UgYSBub3JtYWwg dGFibGUgaW5zdGVhZCwgVFJVTkNBVEUgaXQgYW5kIElOU0VSVCBpbnRvIGl0Pw0KPiANCj4gWW91 cnMsDQo+IExhdXJlbnogQWxiZQ0KDQoNCi0tDQpBZHJpYW4gS2xhdmVyDQphZHJpYW4ua2xhdmVy QGFrbGF2ZXIuY29tDQo=