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

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es

From: Robert Haas <robertmhaas@gmail.com>

To: Justin Pryzby <pryzby@telsasoft.com>

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

Date: 2022-11-29T19:34:01Z

Lists: pgsql-hackers

Attachments

ddl-create-public-reorg-really.patch (application/octet-stream) patch

On Tue, Nov 29, 2022 at 2:32 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
> 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.

D'oh.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

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