Re: Version 14/15 documentation Section "Alter Default Privileges" - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: Version 14/15 documentation Section "Alter Default Privileges"
Date
Msg-id f898e097dbe5e718ec1a6e977d4dda79a6548abb.camel@cybertec.at
Whole thread Raw
In response to Re: Version 14/15 documentation Section "Alter Default Privileges"  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-docs
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

Attachment

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: list of flags that pg_settings_get_flags reports
Next
From: Michael Paquier
Date:
Subject: Re: list of flags that pg_settings_get_flags reports