Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nc9Ov-0003NU-6O for pgsql-committers@arkaria.postgresql.org; Wed, 06 Apr 2022 17:25:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nc9Ot-0002k4-GH for pgsql-committers@arkaria.postgresql.org; Wed, 06 Apr 2022 17:24:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nc9Ot-0002jv-8x for pgsql-committers@lists.postgresql.org; Wed, 06 Apr 2022 17:24:59 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nc9Oq-00087q-K0 for pgsql-committers@lists.postgresql.org; Wed, 06 Apr 2022 17:24:58 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nc9Op-0007lo-0N for pgsql-committers@lists.postgresql.org; Wed, 06 Apr 2022 17:24:55 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nc9On-000bor-Qs for pgsql-committers@lists.postgresql.org; Wed, 06 Apr 2022 17:24:54 +0000 Content-Type: multipart/mixed; boundary="===============6675682771703891141==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow granting SET and ALTER SYSTEM privileges on GUC parameters X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 06 Apr 2022 17:24:54 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6675682771703891141== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgZ3JhbnRpbmcgU0VUIGFuZCBBTFRFUiBTWVNURU0gcHJpdmlsZWdlcyBvbiBHVUMgcGFy YW1ldGVycy4KClRoaXMgcGF0Y2ggYWxsb3dzICJQR0NfU1VTRVQiIHBhcmFtZXRlcnMgdG8gYmUg c2V0IGJ5IG5vbi1zdXBlcnVzZXJzCmlmIHRoZXkgaGF2ZSBiZWVuIGV4cGxpY2l0bHkgZ3JhbnRl ZCB0aGUgcHJpdmlsZWdlIHRvIGRvIHNvLgpUaGUgcHJpdmlsZWdlIHRvIHBlcmZvcm0gQUxURVIg U1lTVEVNIFNFVC9SRVNFVCBvbiBhIHNwZWNpZmljIHBhcmFtZXRlcgpjYW4gYWxzbyBiZSBncmFu dGVkLgpTdWNoIHByaXZpbGVnZXMgYXJlIGNsdXN0ZXItd2lkZSwgbm90IHBlciBkYXRhYmFzZS4g IFRoZXkgYXJlIHRyYWNrZWQKaW4gYSBuZXcgc2hhcmVkIGNhdGFsb2csIHBnX3BhcmFtZXRlcl9h Y2wuCgpHcmFudGluZyBhbmQgcmV2b2tpbmcgdGhlc2UgbmV3IHByaXZpbGVnZXMgd29ya3MgYXMg b25lIHdvdWxkIGV4cGVjdC4KT25lIGNhdmVhdCBpcyB0aGF0IFBHQ19VU0VSU0VUIEdVQ3MgYXJl IHVuYWZmZWN0ZWQgYnkgdGhlIFNFVCBwcml2aWxlZ2UKLS0tIG9uZSBjb3VsZCB3aXNoIHRoYXQg dGhvc2Ugd2VyZSBoYW5kbGVkIGJ5IGEgcmV2b2NhYmxlIGdyYW50IHRvClBVQkxJQywgYnV0IHRo ZXkgYXJlIG5vdCwgYmVjYXVzZSB3ZSBjb3VsZG4ndCBtYWtlIGl0IHJvYnVzdCBlbm91Z2gKZm9y IEdVQ3MgZGVmaW5lZCBieSBleHRlbnNpb25zLgoKTWFyayBEaWxnZXIsIHJldmlld2VkIGF0IHZh cmlvdXMgdGltZXMgYnkgQW5kcmV3IER1bnN0YW4sIFJvYmVydCBIYWFzLApKb3NodWEgQnJpbmRs ZSwgYW5kIG15c2VsZgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8zRDY5MUUyMC1D MUQ1LTRCODAtOEJBNS02QkVCNjNBRjMwMjlAZW50ZXJwcmlzZWRiLmNvbQoKQnJhbmNoCi0tLS0t LQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9j b21taXRkaWZmL2EwZmZhODg1ZTQ3OGY1ZWVhY2M0ZTI1MGUzNWNlMjVhNDc0MGM0ODcKCk1vZGlm aWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAg ICAgICAgICAgICAgICAgICAgIHwgIDc3ICsrLQpkb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwgICAg ICAgICAgICAgICAgICAgICAgICAgICB8IDE1MCArKysrLS0KZG9jL3NyYy9zZ21sL2RkbC5zZ21s ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgNDQgKy0KZG9jL3NyYy9zZ21sL2Z1bmMu c2dtbCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgMjQgKy0KZG9jL3NyYy9zZ21sL3Jl Zi9hbHRlcl9zeXN0ZW0uc2dtbCAgICAgICAgICAgICAgICAgfCAgIDMgKy0KZG9jL3NyYy9zZ21s L3JlZi9kcm9wX293bmVkLnNnbWwgICAgICAgICAgICAgICAgICAgfCAgIDQgKy0KZG9jL3NyYy9z Z21sL3JlZi9ncmFudC5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgfCAgMTcgKy0KZG9jL3Ny Yy9zZ21sL3JlZi9wZ19kdW1wYWxsLnNnbWwgICAgICAgICAgICAgICAgICAgfCAgIDMgKy0KZG9j L3NyYy9zZ21sL3JlZi9yZXZva2Uuc2dtbCAgICAgICAgICAgICAgICAgICAgICAgfCAgIDcgKwpk b2Mvc3JjL3NnbWwvcmVmL3NldC5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgNiAr LQpzcmMvYmFja2VuZC9jYXRhbG9nL01ha2VmaWxlICAgICAgICAgICAgICAgICAgICAgICB8ICAg NCArLQpzcmMvYmFja2VuZC9jYXRhbG9nL2FjbGNoay5jICAgICAgICAgICAgICAgICAgICAgICB8 IDM1NyArKysrKysrKysrKysrLQpzcmMvYmFja2VuZC9jYXRhbG9nL2NhdGFsb2cuYyAgICAgICAg ICAgICAgICAgICAgICB8ICAzNiArLQpzcmMvYmFja2VuZC9jYXRhbG9nL2RlcGVuZGVuY3kuYyAg ICAgICAgICAgICAgICAgICB8ICAgNiArCnNyYy9iYWNrZW5kL2NhdGFsb2cvb2JqZWN0YWRkcmVz cy5jICAgICAgICAgICAgICAgIHwgIDcxICsrKwpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX3BhcmFt ZXRlcl9hY2wuYyAgICAgICAgICAgICB8IDExOCArKysrKwpzcmMvYmFja2VuZC9jb21tYW5kcy9h bHRlci5jICAgICAgICAgICAgICAgICAgICAgICB8ICAgMSArCnNyYy9iYWNrZW5kL2NvbW1hbmRz L2V2ZW50X3RyaWdnZXIuYyAgICAgICAgICAgICAgIHwgICA1ICsKc3JjL2JhY2tlbmQvY29tbWFu ZHMvc2VjbGFiZWwuYyAgICAgICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9jb21t YW5kcy90YWJsZWNtZHMuYyAgICAgICAgICAgICAgICAgICB8ICAgMSArCnNyYy9iYWNrZW5kL3Bh cnNlci9ncmFtLnkgICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDQ2ICstCnNyYy9iYWNrZW5k L3V0aWxzL2FkdC9hY2wuYyAgICAgICAgICAgICAgICAgICAgICAgIHwgMTE0ICsrKysrCnNyYy9i YWNrZW5kL3V0aWxzL2NhY2hlL3N5c2NhY2hlLmMgICAgICAgICAgICAgICAgIHwgIDIzICsKc3Jj L2JhY2tlbmQvdXRpbHMvbWlzYy9ndWMuYyAgICAgICAgICAgICAgICAgICAgICAgfCAxNDYgKysr KystCnNyYy9iaW4vcGdfZHVtcC9kdW1wdXRpbHMuYyAgICAgICAgICAgICAgICAgICAgICAgIHwg ICA3ICstCnNyYy9iaW4vcGdfZHVtcC9wZ19kdW1wYWxsLmMgICAgICAgICAgICAgICAgICAgICAg IHwgIDY1ICsrKwpzcmMvYmluL3BzcWwvdGFiLWNvbXBsZXRlLmMgICAgICAgICAgICAgICAgICAg ICAgICB8ICA3OCArKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAg ICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9kZXBlbmRlbmN5LmggICAgICAg ICAgICAgICAgICAgfCAgIDEgKwpzcmMvaW5jbHVkZS9jYXRhbG9nL29iamVjdGFjY2Vzcy5oICAg ICAgICAgICAgICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3BhcmFtZXRlcl9h Y2wuaCAgICAgICAgICAgICB8ICA2MiArKysKc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wcm9jLmRh dCAgICAgICAgICAgICAgICAgICAgfCAgMTYgKwpzcmMvaW5jbHVkZS9ub2Rlcy9wYXJzZW5vZGVz LmggICAgICAgICAgICAgICAgICAgICB8ICAgNSArLQpzcmMvaW5jbHVkZS9wYXJzZXIva3dsaXN0 LmggICAgICAgICAgICAgICAgICAgICAgICB8ICAgMSArCnNyYy9pbmNsdWRlL3V0aWxzL2FjbC5o ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDExICstCnNyYy9pbmNsdWRlL3V0aWxzL2d1 Yy5oICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAyICsKc3JjL2luY2x1ZGUvdXRpbHMv c3lzY2FjaGUuaCAgICAgICAgICAgICAgICAgICAgICAgfCAgIDIgKwouLi4vdGVzdF9vYXRfaG9v a3MvZXhwZWN0ZWQvdGVzdF9vYXRfaG9va3Mub3V0ICAgICB8IDIxNSArKysrKystLS0KLi4uL21v ZHVsZXMvdGVzdF9vYXRfaG9va3Mvc3FsL3Rlc3Rfb2F0X2hvb2tzLnNxbCAgfCAgNDkgKy0Kc3Jj L3Rlc3QvbW9kdWxlcy90ZXN0X29hdF9ob29rcy90ZXN0X29hdF9ob29rcy5jICAgfCAgODAgKysr LQpzcmMvdGVzdC9tb2R1bGVzL3Rlc3RfcGdfZHVtcC90LzAwMV9iYXNlLnBsICAgICAgICB8ICAz MiArKwpzcmMvdGVzdC9tb2R1bGVzL3Vuc2FmZV90ZXN0cy9NYWtlZmlsZSAgICAgICAgICAgICB8 ICAgMiArLQouLi4vbW9kdWxlcy91bnNhZmVfdGVzdHMvZXhwZWN0ZWQvZ3VjX3ByaXZzLm91dCAg ICB8IDUyNiArKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvbW9kdWxlcy91bnNhZmVfdGVz dHMvc3FsL2d1Y19wcml2cy5zcWwgICAgfCAyMzcgKysrKysrKysrKwo0NCBmaWxlcyBjaGFuZ2Vk LCAyNDY1IGluc2VydGlvbnMoKyksIDE5NCBkZWxldGlvbnMoLSkKCg== --===============6675682771703891141==--