Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEaDj-0001p5-5V for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Jul 2022 17:44:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oEaDi-0000L7-1g for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Jul 2022 17:44:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEaDh-0000Ky-Or for pgsql-hackers@lists.postgresql.org; Thu, 21 Jul 2022 17:44:17 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEaDf-0005cv-Cu for pgsql-hackers@postgresql.org; Thu, 21 Jul 2022 17:44:17 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1oEaDd-003xKa-Fq; Thu, 21 Jul 2022 13:44:13 -0400 Date: Thu, 21 Jul 2022 13:44:13 -0400 From: Bruce Momjian To: Noah Misch Cc: PostgreSQL-development Subject: Re: First draft of the PG 15 release notes Message-ID: References: <20220705195349.GB2648447@rfd.leadboat.com> <20220705215752.GC2648447@rfd.leadboat.com> <20220706024557.GD2648447@rfd.leadboat.com> <20220710031941.GB2808420@rfd.leadboat.com> <20220712063132.GB2937407@rfd.leadboat.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jul 12, 2022 at 02:47:07PM -0400, Bruce Momjian wrote: > On Mon, Jul 11, 2022 at 11:31:32PM -0700, Noah Misch wrote: > > On Mon, Jul 11, 2022 at 12:39:57PM -0400, Bruce Momjian wrote: > > > I had trouble reading the sentences in the order you used so I > > > restructured it: > > > > > > The new default is one of the secure schema usage patterns that > > linkend="ddl-schemas-patterns"/> has recommended since the security > > > release for CVE-2018-1058. The change applies to newly-created > > > databases in existing clusters and for new clusters. Upgrading a > > > cluster or restoring a database dump will preserve existing permissions. > > > > I agree with the sentence order change. > > Great. > > > > For existing databases, especially those having multiple users, consider > > > issuing REVOKE to adopt this new default. For new > > > databases having zero need to defend against insider threats, granting > > > USAGE permission on their public > > > schemas will yield the behavior of prior releases. > > > > s/USAGE/CREATE/ in the last sentence. Looks good with that change. > > Ah, yes, of course. Patch applied, I also adjusted the second paragraph to be more symmetric. You can see the results here: https://momjian.us/pgsql_docs/release-15.html -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson