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

From Michael Banck
Subject Re: Version 14/15 documentation Section "Alter Default Privileges"
Date
Msg-id 653b841d.a70a0220.17f72.2c12@mx.google.com
Whole thread Raw
In response to Re: Version 14/15 documentation Section "Alter Default Privileges"  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Version 14/15 documentation Section "Alter Default Privileges"
List 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



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: A recent message added to pg_upgade
Next
From: shveta malik
Date:
Subject: Re: Synchronizing slots from primary to standby