Message-ID: <f898e097dbe5e718ec1a6e977d4dda79a6548abb.camel@cybertec.at>
Subject: Re: Version 14/15 documentation Section "Alter Default Privileges"
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: David Burns <david.burns@fedex.com>, "pgsql-docs@lists.postgresql.org"
	 <pgsql-docs@lists.postgresql.org>
Date: Fri, 04 Nov 2022 10:49:42 +0100
In-Reply-To: <4a6f157edc4ae38a2050a5893e6729cbb98113bc.camel@cybertec.at>
References: 
	<LV2PR12MB5725F7C1B8EB2FC38829F276E7399@LV2PR12MB5725.namprd12.prod.outlook.com>
	 <4a6f157edc4ae38a2050a5893e6729cbb98113bc.camel@cybertec.at>
Content-Type: multipart/mixed; boundary="=-vLfr5ehwcWUh5yPrq5/d"
User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/f898e097dbe5e718ec1a6e977d4dda79a6548abb.camel%40cybertec.at>
Precedence: bulk


--=-vLfr5ehwcWUh5yPrq5/d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit

On Thu, 2022-11-03 at 11:32 +0100, Laurenz Albe wrote:
> On Wed, 2022-11-02 at 19:29 +0000, David Burns wrote:
> > To Whom It May Concern;
> 
> It concerns me, because I often see questions from people who misunderstand this.
> 
> > Some additional clarity in the versions 14/15 documentation would be helpful specifically
> > surrounding the "target_role" clause for the ALTER DEFAULT PRIVILEGES command.
> > To the uninitiated, the current description seems vague.  Maybe something like the following would help:
> >  
> > target_role
> >        The name of an existing role of which the current role is a member.
> >        Default privileges are only applied to objects created by the targeted role/user (FOR ROLE target_role).
> >        If the FOR ROLE clause is omitted, the targeted user defaults to the current user executing the
> >        ALTER DEFAULT PRIVILEGES command.
> 
> +1

After some more thinking, I came up with the attached patch.

Yours,
Laurenz Albe

--=-vLfr5ehwcWUh5yPrq5/d
Content-Disposition: attachment;
	filename="0001-Improve-ALTER-DEFAULT-PRIVILEGES-documentation.patch"
Content-Transfer-Encoding: base64
Content-Type: text/x-patch;
	name="0001-Improve-ALTER-DEFAULT-PRIVILEGES-documentation.patch";
	charset="UTF-8"

RnJvbSA1ZjdlNjY0YmE2ZmVhMDhkZDVjYWMwYzFjNzFhMGVlNzc1MjJkN2MzIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogRnJpLCA0IE5vdiAyMDIyIDEwOjQ4OjM4ICswMTAwClN1YmplY3Q6IFtQQVRDSF0g
SW1wcm92ZSBBTFRFUiBERUZBVUxUIFBSSVZJTEVHRVMgZG9jdW1lbnRhdGlvbgoKQ2xhcmlmeSB0
aGF0IGRlZmF1bHQgcHJpdmlsZWdlcyBhcmUgb25seSBhcHBsaWVkIHRvIG9iamVjdHMKY3JlYXRl
ZCBieSB0aGUgdGFyZ2V0IHJvbGUuICBUaGlzIGhhcyBiZWVuIGEgZnJlcXVlbnQgc291cmNlCm9m
IG1pc3VuZGVyc3RhbmRpbmdzLgoKQXV0aG9yOiBMYXVyZW56IEFsYmUsIHBlciByZXF1ZXN0IGZy
b20gRGF2aWQgQnVybnMKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9MVjJQUjEyTUI1
NzI1RjdDMUI4RUIyRkMzODgyOUYyNzZFNzM5OSU0MExWMlBSMTJNQjU3MjUubmFtcHJkMTIucHJv
ZC5vdXRsb29rLmNvbQotLS0KIGRvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfZGVmYXVsdF9wcml2aWxl
Z2VzLnNnbWwgfCA1ICsrKysrCiAxIGZpbGUgY2hhbmdlZCwgNSBpbnNlcnRpb25zKCspCgpkaWZm
IC0tZ2l0IGEvZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl9kZWZhdWx0X3ByaXZpbGVnZXMuc2dtbCBi
L2RvYy9zcmMvc2dtbC9yZWYvYWx0ZXJfZGVmYXVsdF9wcml2aWxlZ2VzLnNnbWwKaW5kZXggZjFk
NTRmNWFhMy4uZmNmZjE3ZTY0MiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl9k
ZWZhdWx0X3ByaXZpbGVnZXMuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvcmVmL2FsdGVyX2RlZmF1
bHRfcHJpdmlsZWdlcy5zZ21sCkBAIC0xMzgsNiArMTM4LDExIEBAIFJFVk9LRSBbIEdSQU5UIE9Q
VElPTiBGT1IgXQogICAgICA8cGFyYT4KICAgICAgIFRoZSBuYW1lIG9mIGFuIGV4aXN0aW5nIHJv
bGUgb2Ygd2hpY2ggdGhlIGN1cnJlbnQgcm9sZSBpcyBhIG1lbWJlci4KICAgICAgIElmIDxsaXRl
cmFsPkZPUiBST0xFPC9saXRlcmFsPiBpcyBvbWl0dGVkLCB0aGUgY3VycmVudCByb2xlIGlzIGFz
c3VtZWQuCisgICAgICBEZWZhdWx0IHByaXZpbGVnZXMgYXJlIG9ubHkgYXBwbGllZCB0byBvYmpl
Y3RzIGNyZWF0ZWQgYnkgdGhlCisgICAgICA8cmVwbGFjZWFibGU+dGFyZ2V0X3JvbGU8L3JlcGxh
Y2VhYmxlPi4gIFRoZXJlIGlzIG5vIHdheSB0byBzZXQgZGVmYXVsdAorICAgICAgcHJpdmlsZWdl
cyBmb3Igb2JqZWN0cyBjcmVhdGVkIGJ5IGFyYml0cmFyeSByb2xlczsgZm9yIHRoYXQsIHlvdSdk
IGhhdmUKKyAgICAgIHRvIHJ1biA8Y29tbWFuZD5BTFRFUiBERUZBVUxUIFBSSVZJTEVHRVM8L2Nv
bW1hbmQ+IGZvciBlYWNoIHJvbGUgdGhhdCBjYW4KKyAgICAgIGNyZWF0ZSBvYmplY3RzLgogICAg
ICA8L3BhcmE+CiAgICAgPC9saXN0aXRlbT4KICAgIDwvdmFybGlzdGVudHJ5PgotLSAKMi4zOC4x
Cgo=


--=-vLfr5ehwcWUh5yPrq5/d--