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 1p06Kt-0006P7-Uk for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Nov 2022 19:32:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p06Ks-00048y-Im for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Nov 2022 19:32:06 +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 1p06Ks-00046H-4D for pgsql-hackers@lists.postgresql.org; Tue, 29 Nov 2022 19:32:06 +0000 Received: from mail-io1-xd2a.google.com ([2607:f8b0:4864:20::d2a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p06Kp-0005cS-0S for pgsql-hackers@postgresql.org; Tue, 29 Nov 2022 19:32:05 +0000 Received: by mail-io1-xd2a.google.com with SMTP id r81so10838336iod.2 for ; Tue, 29 Nov 2022 11:32:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=Vlohr474bStmTOotPGuZo2PsFJzM6XznzPifs3NP39s=; b=YVmX3ZWrom3awOkHvRU2A1YLjQ4tDBUTcvjOCX8XGdVZBH2AUzwwxJHxGD3m/3Qj7i nJbCCiSFnJpLotxlRWyAyzDO3dL4Nj1nVFfVmIjAxb3kaIgEsgCw8b1D3Qc3MScHPBSW V16P+8CeGU9CdmcT+RW9+gmnsKpWNvazSwWW+5ZsQHDODhCHd6xTQqPGfC0491ps0fdR ngzbwvRhYAFDR4uCXaarNBGZzMC1Mye+BlBP0Yyz7uYCv47hZHhDi+kutZLmbLF/g2TE N1yDhEoXPRgMZPtT7cZ61lbn+XpcR6gQghd+iQ4M3drIOmT94V+8jt2RQkeS0TE3s7cy 7J/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=Vlohr474bStmTOotPGuZo2PsFJzM6XznzPifs3NP39s=; b=M6QuR4yvPwhp6aae3oH4Q9Ua3f43xiGXvpRRojPjnER+25/5t6nUxqbiqveAlK0Wxo /RkLuWI82PbwXV8ZKtXksLLqo4pWL2Lnk6mtAEB2gaydZE4SxNB9tW1XvzS1oG6jKvcl S6bcnBsM1cwpwhVqA0EvrbrtFW9aXklpv2dIgg4WtnU02xypnm2xUND2N1rww4L3AoTE Rcafxg3GOSrZRSZl8Bmv5L4vYcOMqZQYblpfWlhjH9VyKPoX26NMz00fRsaUwZEoWCZe CpgjAbUr57sj5H7hNvSu9Jhn22ZmI339p8KJ+fd1sWLEtvCYLPtGyp0R3221YybA4mXA TDuw== X-Gm-Message-State: ANoB5pmLKRhpFXucCwdKGXlh1s8oGTeI2SSK1OTBRD+ws9Ud+KpECJTH zIpk+qA5HrhqRcYeOtj+yhXUFw== X-Google-Smtp-Source: AA0mqf6cCJ8r2L2NkPg8G7LAs3GXrq2rVae7ggAHfc0/g7MDEV6ET8QYvkHuvNMCzXT0MIJO8iS/dg== X-Received: by 2002:a05:6638:4419:b0:375:2b75:93d with SMTP id bp25-20020a056638441900b003752b75093dmr17818035jab.235.1669750320659; Tue, 29 Nov 2022 11:32:00 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id f60-20020a0284c2000000b00369a91d1bd4sm5542741jai.138.2022.11.29.11.32.00 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 29 Nov 2022 11:32:00 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 5AC66800BCE; Tue, 29 Nov 2022 13:31:59 -0600 (CST) Date: Tue, 29 Nov 2022 13:31:59 -0600 From: Justin Pryzby To: Robert Haas Cc: Noah Misch , pgsql-hackers@postgresql.org Subject: Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas Message-ID: <20221129193159.GA24131@telsasoft.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.