From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | David Burns <david(dot)burns(at)fedex(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Version 14/15 documentation Section "Alter Default Privileges" |
Date: | 2022-11-04 09:49:42 |
Message-ID: | f898e097dbe5e718ec1a6e977d4dda79a6548abb.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
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 | Content-Type | Size |
---|---|---|
0001-Improve-ALTER-DEFAULT-PRIVILEGES-documentation.patch | text/x-patch | 1.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2022-11-05 03:34:32 | Re: list of flags that pg_settings_get_flags reports |
Previous Message | Tom Lane | 2022-11-03 23:53:55 | Re: list of flags that pg_settings_get_flags reports |
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2022-11-04 09:59:23 | Re: confirmed_flush_lsn shows LSN of the data that has not yet been received by the logical subscriber. |
Previous Message | Hayato Kuroda (Fujitsu) | 2022-11-04 09:46:55 | RE: Perform streaming logical transactions by background workers and parallel apply |