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 654b3102.170a0220.c794a.1f5b@mx.google.com
Whole thread Raw
In response to Re: Version 14/15 documentation Section "Alter Default Privileges"  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Hi,

On Tue, Nov 07, 2023 at 05:30:20PM -0500, Bruce Momjian wrote:
> On Mon, Nov  6, 2023 at 09:53:50PM +0100, Laurenz Albe wrote:
> > +  <para>
> > +   There is no way to change the default privileges for objects created by
> > +   arbitrary roles.  You have run <command>ALTER DEFAULT PRIVILEGES</command>
> 
> I find the above sentence odd.  What is its purpose?

I guess it is to address the main purpose of this patch/confusion with
users: they believe setting DEFAULT PRIVILEGES will set grants
accordingly for all objects created in the future, no matter who creates
them. So hammering in that this is not the case seems fine from my side
(modulo the "You have to run" typo).


Michael



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: ensure, not insure
Next
From: jian he
Date:
Subject: Re: Infinite Interval