Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas

Justin Pryzby <pryzby@telsasoft.com>

From: Justin Pryzby <pryzby@telsasoft.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Noah Misch <noah@leadboat.com>, pgsql-hackers@postgresql.org

Date: 2022-11-29T19:31:59Z

Lists: pgsql-hackers

On Tue, Nov 29, 2022 at 02:22:59PM -0500, Robert Haas wrote:
> Here's a proposed patch to do that.

If I'm not wrong, you message includes a diffstat but without the patch
itself.

Commits

Doc: word-smith the discussion of secure schema usage patterns.
- ef2d7c6f0ba9 16.0 landed
- afa4a4f764cc 15.2 landed
Fix the public schema's permissions in a separate test script.
- 944dc45d1b63 15.0 landed
Revoke PUBLIC CREATE from public schema, now owned by pg_database_owner.
- b073c3ccd06e 15.0 cited