Re: Version 14/15 documentation Section "Alter Default Privileges"

From: Michael Banck <mbanck(at)gmx(dot)net>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: David Burns <david(dot)burns(at)fedex(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Version 14/15 documentation Section "Alter Default Privileges"
Date: 2023-10-27 09:34:20
Message-ID: 653b841d.a70a0220.17f72.2c12@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

Hi,

On Fri, Oct 27, 2023 at 09:03:04AM +0200, Laurenz Albe wrote:
> On Fri, 2022-11-04 at 10:49 +0100, Laurenz Albe wrote:
> > On Thu, 2022-11-03 at 11:32 +0100, Laurenz Albe wrote:
> > > On Wed, 2022-11-02 at 19:29 +0000, David Burns wrote:
> > >
> > > > 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:
> >
> > After some more thinking, I came up with the attached patch.
>
> I'm sending a reply to the hackers list, so that I can add the patch
> to the commitfest.

I think something like this is highly useful because I have also seen
people very confused why default privileges are not applied.

However, maybe it could be made even clearer if also the main
description is amended, like

"You can change default privileges only for objects that will be created
by yourself or by roles that you are a member of (via target_role)."

or something.

Michael

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Gustafsson 2023-10-27 13:15:12 Re: Example 43.6. A PL/pgSQL Trigger Function for Maintaining a Summary Table
Previous Message Laurenz Albe 2023-10-27 07:03:04 Re: Version 14/15 documentation Section "Alter Default Privileges"

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2023-10-27 09:56:55 Re: Synchronizing slots from primary to standby
Previous Message Amit Kapila 2023-10-27 09:27:10 Re: A recent message added to pg_upgade