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 1xGJjP-00000002Dzp-1jpN for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2026 17:22:35 +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 1xGJjO-00000009iYu-1HSa for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2026 17:22:34 +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 1xGJjN-00000009iYk-3a9h for pgsql-general@lists.postgresql.org; Mon, 12 Oct 2026 17:22:33 +0000 Received: from rex-mailout.bayern.de ([193.34.207.154]) by makus.postgresql.org with utf8esmtp (Exim 4.98.2) (envelope-from ) id 1xGJjL-00000001fMV-098l for pgsql-general@postgresql.org; Mon, 12 Oct 2026 17:22:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791825751; x=1807377751; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=3IthqxqzsxEg9HeMyYsg2Oj0rcLLcul01m7eBUxlvyk=; b=QCW7jg6YV5BwcZBxZeASmpLsL9H4MsmIR1VMFuE4Z3zODBSEJDnwRaFU CIDTf//1T0AS9/x0/X66u60ZP7nTAwgPLlxkEcjbUjSx95YiejWl23ymz 5ZzgvLLTPsk5vCvRXwvD2etE8bZmjr8Z0xaSzsvkjzzMopkQTDyyqg75m mQxLhqLAltUjIH9O7lu53Oe1IEMyx487S5gaY320+0eqhrkkRPwPSo5OV BmizCcxZOtXcVCFhEUpIUWJEHQrU210YZaSS/kRQ7X6n41Ir1GAb9pZHp zNnr+3BTurTV1JRchrhbv8cl5vOMcm+mztROemhMkfqUQqeT6CLFt7gqW Q==; X-CSE-ConnectionGUID: ErO4mVJYQZSydJqZqPz7nQ== X-CSE-MsgGUID: EtLF4MdeQGCMceAca0kiRQ== Received: from unknown (HELO rin139.bayern.de) ([10.197.20.139]) by rex145.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 12 Oct 2026 16:59:49 +0200 X-CSE-ConnectionGUID: qUGvX6ykQKK1jIiZ9B9sWQ== X-CSE-MsgGUID: WaTOm3v4TR6iNFUs3YiM5g== X-Talos-CUID: =?us-ascii?q?9a23=3AFW9qFmiqbQh3LuQ9AhhTjD0/zTJua0Dy0keOMky?= =?us-ascii?q?BKkUwSpyUew66qbhbqp87?= X-Talos-MUID: 9a23:RrfeMwpTCqYPjtjzN5gezw5rCOBtuLryNHpTkLMohtLfBC1VZjjI2Q== X-BYBN-routing: post Received: from zmx-ed4-p24375.max.bayern.de ([10.173.241.232]) by rin139.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 12 Oct 2026 16:59:48 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de (10.173.241.200) by ZMX-ED4-P24375.max.bayern.de (10.173.241.232) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.2562.49; Mon, 12 Oct 2026 16:59: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; Mon, 12 Oct 2026 16:59:48 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Adrian Klaver , Laurenz Albe , "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: AQHdUeFL0Utg7jYUl0GDhsYiKoFwtrb5rX5Q Date: Mon, 12 Oct 2026 14:59:48 +0000 Message-ID: References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <2e9d29c1513afb47d652387ea5299076ef24adce.camel@cybertec.at> In-Reply-To: <2e9d29c1513afb47d652387ea5299076ef24adce.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 U29ycnkgZm9yIG15IGxhdGUgcmVwbHkuIFRoYW5rcyBmb3IgcG9pbnRpbmcgc29tZSBzdHVmZiBv dXQuDQoNCj4gT3RoZXIgdGhhbiB0aGF0LCB5b3UgY291bGQgdXNlIGEgdmFyaWFibGUgdGhhdCBp cyBhbiBhcnJheSBvZiB0YWJsZSByb3dzIChkZWNsYXJlZCBhcyBteV90YWJsZVtdKS4NCkEgYml0 IGNsdW1zeSBidXQgeWVzLCB0aGFuayB5b3UuDQoNCkkgYXBwcmVjaWF0ZSBQb3N0Z3JlU1FMLCBi dXQgd2hhdCBzb21ldGltZXMgYmFmZmxlcyBtZSBpcyB0aGF0IFNRTCAob3IgaXMgaXQgUG9zdGdy ZVNRTCkgaXMgLi4uIHdoYXQgc2hvdWxkIEkgY2FsbCBpdD8gTGFja2luZyBtb2R1bGFyaXR5IC8g b3J0aG9nb25hbGl0eT8gU2ltcGx5IHB1dDogV2hlbiB5b3Ugd2FudCB0byBjb21iaW5lIGRpZmZl cmVudCBwYXJ0cywgeW91IHdpbGwgbWVldCBvYnN0YWNsZXMuIE1vcmUgb2JzdGFjbGVzIHRoYW4g b25lIGlzIGFjY3VzdG9tZWQgdG8gd2hlbiBjb21pbmcgZnJvbSBvdGhlciBsYW5ndWFnZXMuIElt cGVyYXRpdmUgb3IgZnVuY3Rpb25hbCBwcm9ncmFtbWluZyBsYW5ndWFnZXMsIHRoYXQgaXMuDQoN CklmIEkgbmVlZCBzb21lIHRlbXBvcmFyeSBzcGFjZSBmb3Igc3RydWN0dXJlZCBkYXRhIGFuZCBh bSByZXN0cmljdGVkIHRvIGF2b2lkIGEgdGVtcCB0YWJsZTsgaWYgSSBhbSB0aGVuIGZvcmNlZCB0 byB1c2UgYSBnbG9iYWwgdGFibGUgKHdoaWNoIG5vdCBvbmx5IGNhbiBiZSBzZWVuIGluIG90aGVy IGNvbm5lY3Rpb25zLCBidXQgbWlnaHQgaW50cm9kdWNlIGNvbmN1cnJlbmN5IGlzc3VlcykuIFRo ZW4gd29yayBhcm91bmQgdXNpbmcgYXJyYXlzLiBJZiBldmVuIGFwcGxpY2FibGUuDQoNCkJlY2F1 c2Ugd2hhdCBJIGhhdmVuJ3Qgc2FpZCB5ZXQgYW5kIHNob3VsZCBhZG1pdCBub3csIHRoZSB0ZW1w IHRhYmxlIGdldHMgZmlsbGVkIHdpdGggQ09QWSAuLi4gRlJPTSBQUk9HUkFNLg0KDQpUaGUgbmV4 dCBvYnN0YWNsZSB3aGljaCBvY2N1cnMgc3RyYW5nZWx5IHRvIG1lIGlzIHRoYXQgQ09QWSAuLi4g RlJPTSBQUk9HUkFNIG9ubHkgY2FuIGR1bXAgZGF0YSBpbnRvIHRhYmxlcy4gT25lIGNhbm5vdCB1 c2UgaXQgbGlrZSBvdGhlciB0YWJsZS1saWtlIG9iamVjdHMsIGxpa2UgYSB2aWV3LCBPbmUgY2Fu bm90IENPUFkgLi4uIEZST00gUFJPR1JBTSBpbnRvIGFuIGFycmF5Lg0KDQpQb3N0Z3JlcyBvZmZl cnMgYWdhaW4gbm8gZmVhc2libGUgd2F5IGZvciB3aGF0IEkgd2FzIHRyeWluZyB0byBhcmNoaWV2 ZS4NCg0KDQpPaywgSSB0aGluayBzb21lIHBlb3BsZSBnZXQgdGhlIHBvaW50IHRoYXQgSSBjbGFp bSBTUUwgLyBQb3N0Z3JlcyBpcyBsYWNraW5nIG1vZHVsYXJpdHkgLyBvcnRob2dvbmFsaXR5IGlu IHRoZSB3YXkgYXMgSSB0cmllZCB0byBkZWZpbmUgYWJvdmUuDQoNCkFuZCBJIHRoaW5rIHNvbWUg cGVvcGxlIHdhbnQgdG8gZGl2ZSBpbnRvIG15IHNwZWNpYWwgdXNlIGNhc2UsIHBlcmhhcHMgY29u c2lkZXIgaXQgYXMga2luZC1vZi1pbnNhbmUuIFNvIGxldCBtZSBleHBsYWluLiBBbmQgcGVyaGFw cyBzb21lYm9keSBjYW4gZ2l2ZSBnb29kIGFkdmljZS4NCg0KKiBJIGFtIHJ1bm5pbmcgUG9zdGdy ZXMgaW4gYSBjb250YWluZXIuDQoqIEkgYW0gdXNpbmcgaHR0cHM6Ly9naXRodWIuY29tL3ByYW1z ZXkvcGdzcWwtaHR0cCB0byBxdWVyeSBSRVNUIHNlcnZpY2VzIHVzaW5nIGNyZWRlbnRpYWxzLg0K KiBJIHRvb2sgaXQgYXMgZ29vZCBhZHZpY2UgdG8gcGFzcyBlbnZpcm9ubWVudCB2YXJpYWJsZXMg aW50byB0aGUgY29udGFpbmVyLCBhbmQgdG8gcGFzcyBwYXNzd29yZHMgYXMgc2luZ2xlIGZpbGVz LCBpbiBtb3VudGVkIGNvbnRhaW5lciBkaXJlY3RvcnkgL3J1bi9zZWNyZXRzLyAuDQoqIEluc2lk ZSBwb3N0Z3JlcyBJIGFtIHRyeWluZyB0byBsb2FkIHRoYXQgZGF0YSwgdXNpbmcgbWVtb2l6YXRp b24gcGF0dGVybi4gRm9yIGV4YW1wbGUgdXNpbmcgQ1JFQVRFIFRFTVAgVEFCTEUgeCAuLi47IENP UFkgeCAuLi4gRlJPTSBQUk9HUkFNICdjYXQgL3J1bi9zZWNyZXRzL215cGFzc3dvcmQnLiBUaGlz IHBhcnQgaXMgZW5jYXBzdWxhdGVkIGFzIGEgZnVuY3Rpb24uDQoNCiogTm93IHRoZXJlIHdhcyBv bmUgcG9pbnQgd2hlcmUgSSB3YXMgdXNpbmcgYSBNQVRFUklBTElaRUQgVklFVyBhY2Nlc3Npbmcg dGhhdCBmdW5jdGlvbi4gQW5kIHdlbGwsIHRoYXQgZmFpbGVkLg0KDQoNCldoYXQgSSBDT1VMRCBk byBpcyByZXBsYWNlIENPUFkgeCAuLi4gRlJPTSBQUk9HUkFNIHdpdGggYSBmaWxlX2ZkdyBGT1JF SUdOIFRBQkxFLCBidXQgdGhpcyB3YXkgaXQgaXNuJ3QgcGFyYW1ldHJpemFibGUuIEkgd291bGQg aGF2ZSB0byBjcmVhdGUgYXMgbWFueSBmb3JlaWduIHRhYmxlcyBhcyBJIGhhdmUgcGFzc3dvcmRz IC8gZW52aXJvbm1lbnQgdmFyaWFibGVzLCBJIHRoaW5rLg0KDQoNClJlZ2FyZHMsDQpGcmFuei1K b3NlZiBGw6RyYmVyDQoNCi0tLS0tVXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0LS0tLS0NClZvbjog TGF1cmVueiBBbGJlIDxsYXVyZW56LmFsYmVAY3liZXJ0ZWMuYXQ+IA0KR2VzZW5kZXQ6IERvbm5l cnN0YWcsIDEuIE9rdG9iZXIgMjAyNiAyMjoxMw0KQW46IEbDpHJiZXIsIEZyYW56LUpvc2VmIChT dE1VSykgPEZyYW56LUpvc2VmLkZhZXJiZXJAc3RtdWsuYmF5ZXJuLmRlPjsgcGdzcWwtZ2VuZXJh bEBwb3N0Z3Jlc3FsLm9yZw0KQ2M6IEhhdXB0LCBNYXR0aGlhcyAoU3RNVUspIDxNYXR0aGlhcy5I YXVwdEBzdG11ay5iYXllcm4uZGU+DQpCZXRyZWZmOiBSZTogV2h5IGlzIG1hdGVyaWFsaXplZCB2 aWV3IGNyZWF0aW9uIGEgInNlY3VyaXR5LXJlc3RyaWN0ZWQgb3BlcmF0aW9uIj8NCg0KT24gVGh1 LCAyMDI2LTEwLTAxIGF0IDEzOjExICswMDAwLCBGw6RyYmVyLCBGcmFuei1Kb3NlZiAoU3RNVUsp IHdyb3RlOg0KPiBzb21lIHF1ZXN0aW9ucyBhYm91dCB0aGlzIDkteWVhci1vbGQgcG9zdCBiZWxv dy4NCj4gWyANCj4gaHR0cHM6Ly9wb3N0Z3IuZXMvbS9mbGF0L0NBRkJvUnpmNkh3Rmcxam92ZE9y YnRDNng0eEtWX18tdDVFalN6YlkyMDY4Uw0KPiAwMXBjVGclNDBtYWlsLmdtYWlsLmNvbSBdDQo+ IA0KPiBJIGFsc28gc3R1bWJsZWQgb3ZlciBhIHNpbWlsYXIgY2FzZSBhcyB0aGUgZmFpbGluZw0K PiANCj4gQ1JFQVRFIE1BVEVSSUFMSVpFRCBWSUVXIHNvbWVfdmlldyBBUyBTRUxFQ1QgKiBGUk9N IG15X2Z1bmMoKTsNCj4gDQo+IC4gd2hlcmUgbXlfZnVuYyB0cmllcyB0byBjcmVhdGUgYSB0ZW1w IHRhYmxlLg0KPiANCj4gV2hlbiB3cml0aW5nIGFuIGFyYml0cmFyaWx5IGNvbXBsZXggZnVuY3Rp b24gbXlfZnVuYywgSSBjbGFpbSB0aGVyZSANCj4gYXJlIGNhc2VzIHdoZW4geW91IHdhbnQgdG8g c3RvcmUgaW50ZXJtZWRpYXRlIHJlc3VsdHMgaW50byB2YXJpYWJsZXMuIEFuZCB3aGF0IGlmIHRo ZSBpbnRlcm1lZGlhdGUgcmVzdWx0cyBhcmUgdGFibGVzPw0KPiBXZWxsLCBQb3N0Z3Jlcy9wbHBn c3FsIGRvZXMgbm90IHN1cHBvcnQgdGFibGUtdmFsdWVkIHZhcmlhYmxlcywgc28gdGhlIG5leHQg YmVzdCBjaG9pY2UgYXJlIHRlbXAgdGFibGVzLg0KPiBCdXQgaGVyZSB3ZSBoYXZlOiBDcmVhdGlu ZyB0ZW1wIHRhYmxlcyBpcyBmb3JiaWRkZW4gaW5zaWRlIGEgbWF0IHZpZXcsIHNlZSB0aGUgbWFp bCBiZWxvdy4NCj4gQmVjYXVzZSB3ZSBtaWdodCBoYXZlIGEgc2lkZSBlZmZlY3QgKCJjaGFuZ2Ug b2Ygc2Vlc2lvbiBzdGF0ZSIpOiBUaGUgY3JlYXRpb24gb2YgdGhpcyB2ZXJ5IHRlbXAgdGFibGUu DQo+IA0KPiBXaGF0IHRvIGRvIG5vdz8gV2VsbCBpdCB0dXJucyBvdXQgSSBhY3R1YWxseSBDQU4g Y3JlYXRlIGEgTk9OLXRlbXAgDQo+IHRhYmxlLiBJcyB0aGF0IHdoYXQgeW91IHdhbnQgbWUgdG8g ZG8/IFJlYWxseT8gSXNuJ3QgdGhpcyB0aGUgYmlnZ2VyIHNpZGUgZWZmZWN0OiBDcmVhdGluZyBh IHRhYmxlPw0KPiANCj4gSXQgYWN0dWFsbHkgZG9lcyBub3QgbWFrZSBzZW5zZSB0byBtZSwgcmVz dHJpY3Rpbmcgb25lIGVmZmVjdCwgd2hpbGUgYWxsb3dpbmcgdGhlIG11Y2ggYmlnZ2VyIGVmZmVj dC4NCg0KQ3JlYXRpbmcgYSB0ZW1wb3JhcnkgdGFibGUgYW5kIGNyZWF0aW5nIGEgcGVybWFuZW50 IHRhYmxlIGFyZSBub3QgdGhlIHNhbWUgdGhpbmc6DQoNCi0gaXQgcmVxdWlyZXMgZGlmZmVyZW50 IHBlcm1pc3Npb25zOiBURU1QIG9uIHRoZSBkYXRhYmFzZSAod2hpY2ggaXMgZ3JhbnRlZCB0byBQ VUJMSUMNCiAgYnkgZGVmYXVsdCkgYW5kIENSRUFURSBvbiBhIHNjaGVtYSAod2hpY2ggb25seSB0 aGUgb3duZXIgaGFzIGJ5IGRlZmF1bHQpDQoNCi0gdGhlIHRlbXBvcmFyeSBzY2hlbWEgYnkgZGVm YXVsdCBpcyBhdCB0aGUgYmVnaW5uaW5nIG9mIHRoZSBzZWFyY2hfcGF0aCwgc28gaXQgY2FuDQog IGVhc2lseSBzaGFkb3cgb2JqZWN0cyBpbiBvdGhlciBzY2hlbWFzDQoNCj4gKiBXaGF0IEkgYWN0 dWFsbHkgbmVlZGVkIGlzIGEgdGFibGUtdmFsdWVkIHZhcmlhYmxlLiBPbmUgSSBjYW4gdXNlIGlu c2lkZSBteSBmdW5jdGlvbi4gV2hpY2ggc2hhbGwNCj4gICBhbHNvIGJlIGxvY2FsL3VuaXF1ZSAo aS4gZS4gbm90IGJlaW5nIHVzZWQgYnkgY29uY3VycmVudCB1c2VycyBvciBzZXNzaW9ucywgb3Ig ZXZlbiBpbiB0aGUgY2FsbA0KPiAgIHN0YWNrIG9mIHRoZSB2ZXJ5IHNhbWUgc2Vzc2lvbikuDQo+ IA0KPiAqIFRoZSBuZXh0IGJlc3QgdGhpbmcgd291bGQgYmUgYSB0ZW1wIHRhYmxlLCBsb2NhbC91 bmlxdWUgaW4gdGhlIHNlbnNlIGFzIGFib3ZlLCB0aGF0IGdldHMgZGVzdHJveWVkDQo+ICAgd2hl biBsZWF2aW5nIHRoZSBmdW5jdGlvbi4NCj4gICBJbnZlbnQgc29tZSBDUkVBVEUgVEVNUCBUQUJM RSAuIE9OIEVYSVQgRlVOQ1RJT04gRFJPUD8NCj4gICAoLmFuZCB3b3VsZG4ndCB0aGF0IGJlIHF1 aXRlIGVxdWl2YWxlbnQgdG8gdGFibGUtdmFsdWVkIHZhcmlhYmxlcz8pDQo+IA0KPiBBbnkgc3Vn Z2VzdGlvbnM/DQoNCklmIHlvdSB1c2UgYSBwZXJtYW5lbnQgdGFibGUgaW5zdGVhZCwgSSByZWNv bW1lbmQgYW4gVU5MT0dHRUQgdGFibGUuDQoNCk90aGVyIHRoYW4gdGhhdCwgeW91IGNvdWxkIHVz ZSBhIHZhcmlhYmxlIHRoYXQgaXMgYW4gYXJyYXkgb2YgdGFibGUgcm93cyAoZGVjbGFyZWQgYXMg bXlfdGFibGVbXSkuDQoNCllvdXJzLA0KTGF1cmVueiBBbGJlDQo=