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.94.2) (envelope-from ) id 1r06bj-003M1l-Fv for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Nov 2023 20:54:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r06bh-001SWH-NV for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Nov 2023 20:54:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r06bh-001SW8-9t for pgsql-hackers@lists.postgresql.org; Mon, 06 Nov 2023 20:54:01 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r06ba-004IBo-5C for pgsql-hackers@lists.postgresql.org; Mon, 06 Nov 2023 20:54:00 +0000 Received: by mail-wm1-x335.google.com with SMTP id 5b1f17b1804b1-40839807e82so30444895e9.0 for ; Mon, 06 Nov 2023 12:53:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1699304032; x=1699908832; darn=lists.postgresql.org; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=gvSBZpZO+t3PAyhY5wenCmvF7KL+OZ9StW/kpTF3hv8=; b=iLFF/8YosbNraFEXBvT8x1GWiFfbq93BM0GgVgdTm0BbiRavMw5Rh5BPrUSu/kdNXd Fh1i2OVH6Sf/G6HVJSpBnSeFYoSeG2P1JQyqzIovzdQDBEntjq92GU/4VDKbq5e8CoTb 5/Ri7caynllyVommFRQvjlk+5KQ2dLX9lDJ6DC8r4pl0tFDFf+60YOmxWQNoQnD9NTn4 wS7c1nuedc76+JW7L+NS8All8tr7wpRSDRQOEujATlR1Fx01W+0MSXO1DGNq6znzMezD mPfGovp2C8RhNAdG+Qc9LNdreTso/owEb5B+tAQqBrJCMHMrL8SJVrHmPRl31L5ijzyo gY6Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699304032; x=1699908832; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=gvSBZpZO+t3PAyhY5wenCmvF7KL+OZ9StW/kpTF3hv8=; b=c5qQLH63Lcq5+bvBAgkCwtVZntvD6RkCJukbQUzOuT53lNamuRfpUetg/gwJ4zHcVo ucHBhTBZfezSNAejvQymG6Q3ewqD0ugXxobbr/yV/GSOQiYev5aT1+JbAVM0YfV2WOG6 j88g1LqtuTiDfSyeTxM8EDVpcGJzP+ouSMkZtlExOt+CRdjQsPfV3JBDfbwiDTJBvttq jcrx8i8GcF8Tbr1ktsugYfth17k/efv58fL1ysEp71OGLFd5AAeu2XKxQeGnDkwsIAqr ZON5IzaZkBqSQr+D3ZrdECvz0XqpVL+iwepuYSmUfgi7O17aHWX6yYIt9fjLXYO7nyMk nWag== X-Gm-Message-State: AOJu0YwvToac4hCGCLTTlnZkVp5cEOvLwm9Jhq/0k2DOqHwQpcRADTVu Ez3cxew5ktjc+uqKPFDOJHWfyg== X-Google-Smtp-Source: AGHT+IE/Z9C8v3QJyS08qtNihtRRtCaF25IuEylCZ3OiEkjWrwHllPfoQzLxy+7YcZ1tmuy5Cq+hxw== X-Received: by 2002:a05:600c:3144:b0:409:6e0e:e95a with SMTP id h4-20020a05600c314400b004096e0ee95amr481508wmo.19.1699304032151; Mon, 06 Nov 2023 12:53:52 -0800 (PST) Received: from localhost.localdomain ([2001:871:260:5129:6ea5:5cea:5172:365b]) by smtp.gmail.com with ESMTPSA id u6-20020a05600c210600b003fe23b10fdfsm13015351wml.36.2023.11.06.12.53.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 06 Nov 2023 12:53:51 -0800 (PST) Message-ID: <06bdd234afabd3144ffaf8e95f42af0f3b38082e.camel@cybertec.at> Subject: Re: Version 14/15 documentation Section "Alter Default Privileges" From: Laurenz Albe To: Bruce Momjian Cc: Michael Banck , David Burns , pgsql-hackers@lists.postgresql.org Date: Mon, 06 Nov 2023 21:53:50 +0100 In-Reply-To: References: <653b841d.a70a0220.17f72.2c12@mx.google.com> <7de5f33f49a91d7b30b8c01fe46fc280713ebae1.camel@cybertec.at> <653cce08.050a0220.a10fb.7878@mx.google.com> <244e0f9e3300f165ff578302e942fa3145dedfc7.camel@cybertec.at> Content-Type: multipart/mixed; boundary="=-zUMgYB0GOSxUlFNu1y8B" User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-zUMgYB0GOSxUlFNu1y8B Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, 2023-11-06 at 10:55 -0500, Bruce Momjian wrote: > Okay, I think I have good wording for this. I didn't like the wording > of other roles, so I restructured that in the attached patch too. > > ! Default privileges apply only to the active role; the default > ! privileges of member roles have no affect on object permissions. > ! SET ROLE can be used to change the active user an= d > ! apply their default privileges. > ! You don't mean member roles, but roles that the active role is a member of, right? How do you like my version, as attached? Yours, Laurenz Albe --=-zUMgYB0GOSxUlFNu1y8B Content-Disposition: attachment; filename="v3-0001-Improve-ALTER-DEFAULT-PRIVILEGES-documentation.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="v3-0001-Improve-ALTER-DEFAULT-PRIVILEGES-documentation.patch"; charset="UTF-8" RnJvbSBlYjI1MWYwMDAwNzRlZTEwZWZmNWNiZDMwY2E5ZWUwMzhhMDFiNmYzIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogTW9uLCA2IE5vdiAyMDIzIDIxOjQ0OjIzICswMTAwClN1YmplY3Q6IFtQQVRDSF0g SW1wcm92ZSBBTFRFUiBERUZBVUxUIFBSSVZJTEVHRVMgZG9jdW1lbnRhdGlvbgoKUmV3cml0ZSB0 aGUgZG9jdW1lbnRhdGlvbiB0byBlbXBoYXNpemUgdHdvIGFzcGVjdHMgdGhhdCB3ZXJlCnByZXZp b3VzbHkgbWlzc2luZywgd2hpY2ggZnJlcXVlbnRseSBjb25mdXNlZCB1c2VyczoKCi0geW91IGNh bm5vdCBpbmhlcml0IGFsdGVyZWQgZGVmYXVsdCBwcml2aWxlZ2VzCgotIHlvdSBjYW5ub3QgYWx0 ZXIgdGhlIGRlZmF1bHQgcHJpdmlsZWdlcyBmb3IgYW55IGNyZWF0aW5nCiAgcm9sZSBieSBvbWl0 dGluZyBGT1IgUk9MRQoKQXV0aG9yOiBCcnVjZSBNb21qaWFuLCBMYXVyZW56IEFsYmUKUmV2aWV3 ZWQtYnk6IE1pY2hhZWwgQmFuY2sKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9MVjJQ UjEyTUI1NzI1RjdDMUI4RUIyRkMzODgyOUYyNzZFNzM5OSU0MExWMlBSMTJNQjU3MjUubmFtcHJk MTIucHJvZC5vdXRsb29rLmNvbQotLS0KIC4uLi9zZ21sL3JlZi9hbHRlcl9kZWZhdWx0X3ByaXZp bGVnZXMuc2dtbCAgICB8IDUyICsrKysrKysrKysrKy0tLS0tLS0KIDEgZmlsZSBjaGFuZ2VkLCAz MyBpbnNlcnRpb25zKCspLCAxOSBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3Nn bWwvcmVmL2FsdGVyX2RlZmF1bHRfcHJpdmlsZWdlcy5zZ21sIGIvZG9jL3NyYy9zZ21sL3JlZi9h bHRlcl9kZWZhdWx0X3ByaXZpbGVnZXMuc2dtbAppbmRleCBmMWQ1NGY1YWEzLi43ZmFiNzA3YTBk IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX2RlZmF1bHRfcHJpdmlsZWdlcy5z Z21sCisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfZGVmYXVsdF9wcml2aWxlZ2VzLnNnbWwK QEAgLTkwLDM0ICs5MCw0NyBAQCBSRVZPS0UgWyBHUkFOVCBPUFRJT04gRk9SIF0KICAgPHBhcmE+ CiAgICA8Y29tbWFuZD5BTFRFUiBERUZBVUxUIFBSSVZJTEVHRVM8L2NvbW1hbmQ+IGFsbG93cyB5 b3UgdG8gc2V0IHRoZSBwcml2aWxlZ2VzCiAgICB0aGF0IHdpbGwgYmUgYXBwbGllZCB0byBvYmpl Y3RzIGNyZWF0ZWQgaW4gdGhlIGZ1dHVyZS4gIChJdCBkb2VzIG5vdAotICAgYWZmZWN0IHByaXZp bGVnZXMgYXNzaWduZWQgdG8gYWxyZWFkeS1leGlzdGluZyBvYmplY3RzLikgIEN1cnJlbnRseSwK LSAgIG9ubHkgdGhlIHByaXZpbGVnZXMgZm9yIHNjaGVtYXMsIHRhYmxlcyAoaW5jbHVkaW5nIHZp ZXdzIGFuZCBmb3JlaWduCi0gICB0YWJsZXMpLCBzZXF1ZW5jZXMsIGZ1bmN0aW9ucywgYW5kIHR5 cGVzIChpbmNsdWRpbmcgZG9tYWlucykgY2FuIGJlCi0gICBhbHRlcmVkLiAgRm9yIHRoaXMgY29t bWFuZCwgZnVuY3Rpb25zIGluY2x1ZGUgYWdncmVnYXRlcyBhbmQgcHJvY2VkdXJlcy4KLSAgIFRo ZSB3b3JkcyA8bGl0ZXJhbD5GVU5DVElPTlM8L2xpdGVyYWw+IGFuZCA8bGl0ZXJhbD5ST1VUSU5F UzwvbGl0ZXJhbD4gYXJlCi0gICBlcXVpdmFsZW50IGluIHRoaXMgY29tbWFuZC4gICg8bGl0ZXJh bD5ST1VUSU5FUzwvbGl0ZXJhbD4gaXMgcHJlZmVycmVkCi0gICBnb2luZyBmb3J3YXJkIGFzIHRo ZSBzdGFuZGFyZCB0ZXJtIGZvciBmdW5jdGlvbnMgYW5kIHByb2NlZHVyZXMgdGFrZW4KLSAgIHRv Z2V0aGVyLiAgSW4gZWFybGllciBQb3N0Z3JlU1FMIHJlbGVhc2VzLCBvbmx5IHRoZQotICAgd29y ZCA8bGl0ZXJhbD5GVU5DVElPTlM8L2xpdGVyYWw+IHdhcyBhbGxvd2VkLiAgSXQgaXMgbm90IHBv c3NpYmxlIHRvIHNldAotICAgZGVmYXVsdCBwcml2aWxlZ2VzIGZvciBmdW5jdGlvbnMgYW5kIHBy b2NlZHVyZXMgc2VwYXJhdGVseS4pCi0gIDwvcGFyYT4KLQotICA8cGFyYT4KLSAgIFlvdSBjYW4g Y2hhbmdlIGRlZmF1bHQgcHJpdmlsZWdlcyBvbmx5IGZvciBvYmplY3RzIHRoYXQgd2lsbCBiZSBj cmVhdGVkIGJ5Ci0gICB5b3Vyc2VsZiBvciBieSByb2xlcyB0aGF0IHlvdSBhcmUgYSBtZW1iZXIg b2YuICBUaGUgcHJpdmlsZWdlcyBjYW4gYmUgc2V0Ci0gICBnbG9iYWxseSAoaS5lLiwgZm9yIGFs bCBvYmplY3RzIGNyZWF0ZWQgaW4gdGhlIGN1cnJlbnQgZGF0YWJhc2UpLAotICAgb3IganVzdCBm b3Igb2JqZWN0cyBjcmVhdGVkIGluIHNwZWNpZmllZCBzY2hlbWFzLgorICAgYWZmZWN0IHByaXZp bGVnZXMgYXNzaWduZWQgdG8gYWxyZWFkeS1leGlzdGluZyBvYmplY3RzLikgIFByaXZpbGVnZXMg Y2FuIGJlCisgICBzZXQgZ2xvYmFsbHkgKGkuZS4sIGZvciBhbGwgb2JqZWN0cyBjcmVhdGVkIGlu IHRoZSBjdXJyZW50IGRhdGFiYXNlKSwgb3IKKyAgIGp1c3QgZm9yIG9iamVjdHMgY3JlYXRlZCBp biBzcGVjaWZpZWQgc2NoZW1hcy4KICAgPC9wYXJhPgogCiAgIDxwYXJhPgogICAgQXMgZXhwbGFp bmVkIGluIDx4cmVmIGxpbmtlbmQ9ImRkbC1wcml2Ii8+LAogICAgdGhlIGRlZmF1bHQgcHJpdmls ZWdlcyBmb3IgYW55IG9iamVjdCB0eXBlIG5vcm1hbGx5IGdyYW50IGFsbCBncmFudGFibGUKICAg IHBlcm1pc3Npb25zIHRvIHRoZSBvYmplY3Qgb3duZXIsIGFuZCBtYXkgZ3JhbnQgc29tZSBwcml2 aWxlZ2VzIHRvCiAgICA8bGl0ZXJhbD5QVUJMSUM8L2xpdGVyYWw+IGFzIHdlbGwuICBIb3dldmVy LCB0aGlzIGJlaGF2aW9yIGNhbiBiZSBjaGFuZ2VkIGJ5CiAgICBhbHRlcmluZyB0aGUgZ2xvYmFs IGRlZmF1bHQgcHJpdmlsZWdlcyB3aXRoCiAgICA8Y29tbWFuZD5BTFRFUiBERUZBVUxUIFBSSVZJ TEVHRVM8L2NvbW1hbmQ+LgogICA8L3BhcmE+CiAKKyAgPHBhcmE+CisgICBBcyBhIG5vbi1zdXBl cnVzZXIsIHlvdSBjYW4gY2hhbmdlIGRlZmF1bHQgcHJpdmlsZWdlcyBvbmx5IG9uIG9iamVjdHMg Y3JlYXRlZAorICAgYnkgeW91cnNlbGYgb3IgYnkgcm9sZXMgdGhhdCB5b3UgYXJlIGEgbWVtYmVy IG9mLiAgSG93ZXZlciwgeW91IGRvbid0IGluaGVyaXQKKyAgIGFsdGVyZWQgZGVmYXVsdCBwcml2 aWxlZ2VzIGZyb20gcm9sZXMgeW91IGFyZSBhIG1lbWJlciBvZjsgb2JqZWN0cyB5b3UgY3JlYXRl CisgICB3aWxsIHJlY2VpdmUgdGhlIGRlZmF1bHQgcHJpdmlsZWdlcyBmb3IgeW91ciBjdXJyZW50 IHJvbGUuCisgIDwvcGFyYT4KKworICA8cGFyYT4KKyAgIFRoZXJlIGlzIG5vIHdheSB0byBjaGFu Z2UgdGhlIGRlZmF1bHQgcHJpdmlsZWdlcyBmb3Igb2JqZWN0cyBjcmVhdGVkIGJ5CisgICBhcmJp dHJhcnkgcm9sZXMuICBZb3UgaGF2ZSBydW4gPGNvbW1hbmQ+QUxURVIgREVGQVVMVCBQUklWSUxF R0VTPC9jb21tYW5kPgorICAgZm9yIGFueSByb2xlIHRoYXQgY2FuIGNyZWF0ZSBvYmplY3RzIHdo b3NlIGRlZmF1bHQgcHJpdmlsZWdlcyBzaG91bGQgYmUKKyAgIG1vZGlmaWVkLgorICA8L3BhcmE+ CisKKyAgPHBhcmE+CisgICBDdXJyZW50bHksCisgICBvbmx5IHRoZSBwcml2aWxlZ2VzIGZvciBz Y2hlbWFzLCB0YWJsZXMgKGluY2x1ZGluZyB2aWV3cyBhbmQgZm9yZWlnbgorICAgdGFibGVzKSwg c2VxdWVuY2VzLCBmdW5jdGlvbnMsIGFuZCB0eXBlcyAoaW5jbHVkaW5nIGRvbWFpbnMpIGNhbiBi ZQorICAgYWx0ZXJlZC4gIEZvciB0aGlzIGNvbW1hbmQsIGZ1bmN0aW9ucyBpbmNsdWRlIGFnZ3Jl Z2F0ZXMgYW5kIHByb2NlZHVyZXMuCisgICBUaGUgd29yZHMgPGxpdGVyYWw+RlVOQ1RJT05TPC9s aXRlcmFsPiBhbmQgPGxpdGVyYWw+Uk9VVElORVM8L2xpdGVyYWw+IGFyZQorICAgZXF1aXZhbGVu dCBpbiB0aGlzIGNvbW1hbmQuICAoPGxpdGVyYWw+Uk9VVElORVM8L2xpdGVyYWw+IGlzIHByZWZl cnJlZAorICAgZ29pbmcgZm9yd2FyZCBhcyB0aGUgc3RhbmRhcmQgdGVybSBmb3IgZnVuY3Rpb25z IGFuZCBwcm9jZWR1cmVzIHRha2VuCisgICB0b2dldGhlci4gIEluIGVhcmxpZXIgUG9zdGdyZVNR TCByZWxlYXNlcywgb25seSB0aGUKKyAgIHdvcmQgPGxpdGVyYWw+RlVOQ1RJT05TPC9saXRlcmFs PiB3YXMgYWxsb3dlZC4gIEl0IGlzIG5vdCBwb3NzaWJsZSB0byBzZXQKKyAgIGRlZmF1bHQgcHJp dmlsZWdlcyBmb3IgZnVuY3Rpb25zIGFuZCBwcm9jZWR1cmVzIHNlcGFyYXRlbHkuKQorICA8L3Bh cmE+CisKICAgPHBhcmE+CiAgICBEZWZhdWx0IHByaXZpbGVnZXMgdGhhdCBhcmUgc3BlY2lmaWVk IHBlci1zY2hlbWEgYXJlIGFkZGVkIHRvIHdoYXRldmVyCiAgICB0aGUgZ2xvYmFsIGRlZmF1bHQg cHJpdmlsZWdlcyBhcmUgZm9yIHRoZSBwYXJ0aWN1bGFyIG9iamVjdCB0eXBlLgpAQCAtMTM2LDgg KzE0OSw5IEBAIFJFVk9LRSBbIEdSQU5UIE9QVElPTiBGT1IgXQogICAgIDx0ZXJtPjxyZXBsYWNl YWJsZT50YXJnZXRfcm9sZTwvcmVwbGFjZWFibGU+PC90ZXJtPgogICAgIDxsaXN0aXRlbT4KICAg ICAgPHBhcmE+Ci0gICAgICBUaGUgbmFtZSBvZiBhbiBleGlzdGluZyByb2xlIG9mIHdoaWNoIHRo ZSBjdXJyZW50IHJvbGUgaXMgYSBtZW1iZXIuCi0gICAgICBJZiA8bGl0ZXJhbD5GT1IgUk9MRTwv bGl0ZXJhbD4gaXMgb21pdHRlZCwgdGhlIGN1cnJlbnQgcm9sZSBpcyBhc3N1bWVkLgorICAgICAg RGVmYXVsdCBwcml2aWxlZ2VzIGFyZSBjaGFuZ2VkIGZvciBvYmplY3RzIGNyZWF0ZWQgYnkgdGhl CisgICAgICA8cmVwbGFjZWFibGU+dGFyZ2V0X3JvbGU8L3JlcGxhY2VhYmxlPiwgb3IgdGhlIGN1 cnJlbnQKKyAgICAgIHJvbGUgaWYgdW5zcGVjaWZpZWQuCiAgICAgIDwvcGFyYT4KICAgICA8L2xp c3RpdGVtPgogICAgPC92YXJsaXN0ZW50cnk+Ci0tIAoyLjQxLjAKCg== --=-zUMgYB0GOSxUlFNu1y8B--