pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Michael Banck <mbanck@gmx.net>
To: Bruce Momjian <bruce@momjian.us>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: David Burns <david.burns@fedex.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Version 14/15 documentation Section "Alter Default Privileges"
Date: Wed, 8 Nov 2023 07:56:02 +0100
Message-ID: <654b3102.170a0220.c794a.1f5b@mx.google.com> (raw)
In-Reply-To: <ZUq6fAsQZsyUAySx@momjian.us>
References: <653cce08.050a0220.a10fb.7878@mx.google.com>
	<ZUUlmpxzsZMSZ7N_@momjian.us>
	<b227432f87266b680fd6f31e37b202b2fae5d9b6.camel@cybertec.at>
	<ZUaLgyKdfWeh6nlj@momjian.us>
	<244e0f9e3300f165ff578302e942fa3145dedfc7.camel@cybertec.at>
	<ZUbsWcPypVORlYCg@momjian.us>
	<ceac8e2df89a5eb1335ad8ce39c6ba0beaeddde3.camel@cybertec.at>
	<ZUkMi9UhnfHyIQMf@momjian.us>
	<06bdd234afabd3144ffaf8e95f42af0f3b38082e.camel@cybertec.at>
	<ZUq6fAsQZsyUAySx@momjian.us>

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





view thread (24+ messages)  latest in thread

Message-ID: <654b3102.170a0220.c794a.1f5b@mx.google.com>
Permalink:  ../654b3102.170a0220.c794a.1f5b@mx.google.com/
Also on:    postgresql.org/message-id/654b3102.170a0220.c794a.1f5b@mx.google.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: mbanck@gmx.net, bruce@momjian.us, laurenz.albe@cybertec.at, david.burns@fedex.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: Version 14/15 documentation Section "Alter Default Privileges"
  In-Reply-To: <654b3102.170a0220.c794a.1f5b@mx.google.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox