Re: public schema default ACL

From: Noah Misch <noah(at)leadboat(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Stephen Frost <sfrost(at)snowman(dot)net>, Magnus Hagander <magnus(at)hagander(dot)net>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: public schema default ACL
Date: 2021-09-04 16:18:17
Message-ID: 20210904161817.GB2326091@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 02, 2021 at 12:36:51PM +0200, Peter Eisentraut wrote:
> I think this patch represents the consensus.
>
> The documentation looks okay. Some places still refer to PostgreSQL 13,
> which should now be changed to 14.

Thanks. I'll update s/13/14/ and/or s/14/15/ before the next step.

> I tried a couple of upgrade scenarios and it appeared to do the right thing.
>
> This patch is actually two separate changes: First, change the owner of the
> public schema to "pg_database_owner"; second, change the default privileges
> set on the public schema by initdb. I was a bit surprised that the former
> hadn't already be done in PG14.

Interesting. That change requires a7a7be1, which is also not in v14.

Do you plan to change the CF entry, or should it remain in Needs Review with
no assigned reviewer?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2021-09-04 16:22:05 Re: prevent immature WAL streaming
Previous Message Tom Lane 2021-09-04 15:32:26 Re: [PATCH] support tab-completion for single quote input with equal sign