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 1xGaoT-00000002Ufi-0w07 for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 11:36:58 +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 1xGaoR-0000000Dkh8-3Zbd for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 11:36:55 +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 1xGaoR-0000000Dkgz-1yDV for pgsql-general@lists.postgresql.org; Tue, 13 Oct 2026 11:36:55 +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 1xGaoO-00000001nMJ-00z9 for pgsql-general@postgresql.org; Tue, 13 Oct 2026 11:36:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791891412; x=1807443412; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=FAh9WVYOnCKqvNjNxlMN3jvexLRCCMd/Ie4xnKRQiWo=; b=fSDJrppISzRJ0glAHStxWp+DN1Je/blUJzZC6k6qGihDjBVfntMRDCg2 YDwvaq3VP2xSCUHdVlWf56QV7Ml8D17bteR3usp3qa4HDIlxgaKAX8PI8 xD0zTL/xUC/LjOdmDAnGdQEvHjFZmKGAmz1M2CQukOs5CAHhg232JJXOs 4UC/v5w2RkVzHfz8eiFWXX8Km8xsdOz73EpsecghNakA/70YHqwqAH14L mPb76e+FzSP5I2EZAZSwkM2HjJeMItXCj2eCY8xGNZQXeCwecgkAklBIq YtVWwZIUiijl83qZ6PClRLxclT5JlsYuF5exRGvnGFHMA5aj/nnKfzstr w==; X-CSE-ConnectionGUID: 4ERyG6owRN2r5aIaa8HwqA== X-CSE-MsgGUID: 0G5tPNBbQDu5NxQCGieNbg== Received: from unknown (HELO rin129.bayern.de) ([10.197.20.129]) by rex137.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 13 Oct 2026 13:36:48 +0200 X-CSE-ConnectionGUID: SIHbkpy3SGCi9Ispg/2KYg== X-CSE-MsgGUID: 4Ndu/pdrRYGSDWPdvrGvsA== X-Talos-CUID: 9a23:jBKx1m05BE096Ni/cPXhk7xfIeEFeH7F3SzrDGS5WEdyULLSE3yh9/Yx X-Talos-MUID: 9a23:IuG1mQqdSMjS2n6f9vAez21EONov+6i0MnEiqrk5g8WaLwNuIB7I2Q== X-BYBN-routing: post Received: from zmx-ed1-p24372.max.bayern.de ([10.173.241.233]) by rin129.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Oct 2026 13:36:48 +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; Tue, 13 Oct 2026 13:36:48 +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; Tue, 13 Oct 2026 13:36:48 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Laurenz Albe , Adrian Klaver , "pgsql-general@postgresql.org" CC: "Haupt, Matthias (StMUK)" Subject: AW: Why is materialized view creation a "security-restricted operation"? Thread-Topic: Why is materialized view creation a "security-restricted operation"? Thread-Index: AQHdUeFL0Utg7jYUl0GDhsYiKoFwtrb5rX5QgAGS4oCAACfpcA== Date: Tue, 13 Oct 2026 11:36:48 +0000 Message-ID: <5628a96712e14b9fac594b34b0eb9161@stmuk.bayern.de> References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <2e9d29c1513afb47d652387ea5299076ef24adce.camel@cybertec.at> <4d7467aa0ee958343fca8c6bd6720952b5bc08b1.camel@cybertec.at> In-Reply-To: <4d7467aa0ee958343fca8c6bd6720952b5bc08b1.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 Pj4gW3JhbnQgYWJvdXQgUG9zdGdyZVNRTCBzZWN1cml0eSByZXN0cmljdGlvbnNdDQpObyBubyBu bywgbm90IGFib3V0IHNlY3VyaXR5IHJlc3RyaWN0aW9ucy4gVGhlIHJhbnQgaXMgYWJvdXQgbGFj a2luZyBvcnRob2dvbmFsaXR5LiBBYm91dCBvZnRlbiBOT1QgYmVpbmcgYWJsZSB0byBjb21iaW5l IGxhbmd1YWdlIGZlYXR1cmVzLiBEb2Vzbid0IGFueWJvZHkgc2hhcmUgdGhhdCB2aWV3PyBXZSBD T1VMRCBkbyBiZXR0ZXIsIEkgdGhpbmsuDQoNCj4gSWYgdGhlIHNlY3VyaXR5IHJlc3RyaWN0aW9u cyBvZiBtYXRlcmlhbGl6ZWQgdmlld3MgcHJldmVudCB5b3UgZnJvbSB1c2luZyB0aGVtLCB3aHkg ZG9uJ3QgeW91IHVzZSBhIG5vcm1hbCB0YWJsZSBpbnN0ZWFkLCBUUlVOQ0FURSBpdCBhbmQgSU5T RVJUIGludG8gaXQ/DQpUaGUgTUFUIFZJRVcgaXMgdXNlZCBmcm9tICJvdXRzaWRlIi4gRnJvbSBv dGhlciB2aWV3cywgb3IgZnJvbSBhIGNsaWVudCB0aGF0IGNvbm5lY3RzIHRvIHRoZSBkYXRhYmFz ZS4NCg0KKiBJIGNhbiByZXBsYWNlIGl0IHdpdGggYSB2aWV3OyBJIGRpZG4ndCBkbyB0aGF0IGZv ciBwZXJmb3JtYW5jZSByZWFzb25zLg0KKiBJIGNhbiByZXBsYWNlIGl0IHdpdGggYSBwZXJzaXN0 ZW50IHRhYmxlLCBhIHN0b3JlZCBwcm9jZWR1cmUsIGFuZCBjdXN0b20gY2FjaGluZyBsb2dpYy4g VGhhdCdsbCB3b3JrLiBCdXQgdGhpcyBpcyB3aGF0IGEgTUFUIFZJRVcgaXMgZm9yLCBJIHRob3Vn aHQuIA0KDQoNClJlZ2FyZHMsDQpGcmFuei1Kb3NlZiBGw6RyYmVyDQoNCi0tLS0tVXJzcHLDvG5n bGljaGUgTmFjaHJpY2h0LS0tLS0NClZvbjogTGF1cmVueiBBbGJlIDxsYXVyZW56LmFsYmVAY3li ZXJ0ZWMuYXQ+IA0KR2VzZW5kZXQ6IERpZW5zdGFnLCAxMy4gT2t0b2JlciAyMDI2IDEzOjA2DQpB bjogRsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKSA8RnJhbnotSm9zZWYuRmFlcmJlckBzdG11 ay5iYXllcm4uZGU+OyBBZHJpYW4gS2xhdmVyIDxhZHJpYW4ua2xhdmVyQGFrbGF2ZXIuY29tPjsg cGdzcWwtZ2VuZXJhbEBwb3N0Z3Jlc3FsLm9yZw0KQ2M6IEhhdXB0LCBNYXR0aGlhcyAoU3RNVUsp IDxNYXR0aGlhcy5IYXVwdEBzdG11ay5iYXllcm4uZGU+DQpCZXRyZWZmOiBSZTogV2h5IGlzIG1h dGVyaWFsaXplZCB2aWV3IGNyZWF0aW9uIGEgInNlY3VyaXR5LXJlc3RyaWN0ZWQgb3BlcmF0aW9u Ij8NCg0KT24gTW9uLCAyMDI2LTEwLTEyIGF0IDE0OjU5ICswMDAwLCBGw6RyYmVyLCBGcmFuei1K b3NlZiAoU3RNVUspIHdyb3RlOg0KDQo+IFtyYW50IGFib3V0IFBvc3RncmVTUUwgc2VjdXJpdHkg cmVzdHJpY3Rpb25zXQ0KPg0KPiBPaywgSSB0aGluayBzb21lIHBlb3BsZSBnZXQgdGhlIHBvaW50 IHRoYXQgSSBjbGFpbSBTUUwgLyBQb3N0Z3JlcyBpcyANCj4gbGFja2luZyBtb2R1bGFyaXR5IC8g b3J0aG9nb25hbGl0eSBpbiB0aGUgd2F5IGFzIEkgdHJpZWQgdG8gZGVmaW5lIGFib3ZlLg0KDQpJ IGRvbid0LiAgSnVzdCBiZWNhdXNlIHRoZSBmZWF0dXJlcyB5b3UgYXJlIHN0YWNraW5nIGRvbid0 IHdvcmsgdGhlIHdheSB5b3UnZCBsaWtlIHRoZW0gdG8sIGl0J3Mgbm90IGEgc2hvcnRjb21pbmcg b2Ygb3J0aG9nb25hbGl0eSBvciBtb2R1bGFyaXR5Lg0KDQo+IFNvIGxldCBtZSBleHBsYWluLiBB bmQgcGVyaGFwcyBzb21lYm9keSBjYW4gZ2l2ZSBnb29kIGFkdmljZS4NCj4gDQo+ICogSSBhbSBy dW5uaW5nIFBvc3RncmVzIGluIGEgY29udGFpbmVyLg0KPiAqIEkgYW0gdXNpbmcgaHR0cHM6Ly9n aXRodWIuY29tL3ByYW1zZXkvcGdzcWwtaHR0cCB0byBxdWVyeSBSRVNUIHNlcnZpY2VzIHVzaW5n IGNyZWRlbnRpYWxzLg0KPiAqIEkgdG9vayBpdCBhcyBnb29kIGFkdmljZSB0byBwYXNzIGVudmly b25tZW50IHZhcmlhYmxlcyBpbnRvIHRoZSBjb250YWluZXIsIGFuZCB0byBwYXNzDQo+ICAgcGFz c3dvcmRzIGFzIHNpbmdsZSBmaWxlcywgaW4gbW91bnRlZCBjb250YWluZXIgZGlyZWN0b3J5IC9y dW4vc2VjcmV0cy8gLg0KPiAqIEluc2lkZSBwb3N0Z3JlcyBJIGFtIHRyeWluZyB0byBsb2FkIHRo YXQgZGF0YSwgdXNpbmcgbWVtb2l6YXRpb24gcGF0dGVybi4gRm9yIGV4YW1wbGUgdXNpbmcNCj4g ICBDUkVBVEUgVEVNUCBUQUJMRSB4IC4uLjsgQ09QWSB4IC4uLiBGUk9NIFBST0dSQU0gJ2NhdCAv cnVuL3NlY3JldHMvbXlwYXNzd29yZCcuDQo+ICAgVGhpcyBwYXJ0IGlzIGVuY2Fwc3VsYXRlZCBh cyBhIGZ1bmN0aW9uLg0KPiANCj4gKiBOb3cgdGhlcmUgd2FzIG9uZSBwb2ludCB3aGVyZSBJIHdh cyB1c2luZyBhIE1BVEVSSUFMSVpFRCBWSUVXIGFjY2Vzc2luZyB0aGF0IGZ1bmN0aW9uLg0KPiAg IEFuZCB3ZWxsLCB0aGF0IGZhaWxlZC4NCj4gDQo+IFdoYXQgSSBDT1VMRCBkbyBpcyByZXBsYWNl IENPUFkgeCAuLi4gRlJPTSBQUk9HUkFNIHdpdGggYSBmaWxlX2ZkdyANCj4gRk9SRUlHTiBUQUJM RSwgYnV0IHRoaXMgd2F5IGl0IGlzbid0IHBhcmFtZXRyaXphYmxlLiBJIHdvdWxkIGhhdmUgdG8g DQo+IGNyZWF0ZSBhcyBtYW55IGZvcmVpZ24gdGFibGVzIGFzIEkgaGF2ZSBwYXNzd29yZHMgLyBl bnZpcm9ubWVudCB2YXJpYWJsZXMsIEkgdGhpbmsuDQoNCklmIHRoZSBzZWN1cml0eSByZXN0cmlj dGlvbnMgb2YgbWF0ZXJpYWxpemVkIHZpZXdzIHByZXZlbnQgeW91IGZyb20gdXNpbmcgdGhlbSwg d2h5IGRvbid0IHlvdSB1c2UgYSBub3JtYWwgdGFibGUgaW5zdGVhZCwgVFJVTkNBVEUgaXQgYW5k IElOU0VSVCBpbnRvIGl0Pw0KDQpZb3VycywNCkxhdXJlbnogQWxiZQ0K