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 1mOaC2-0004p2-P3 for pgsql-committers@arkaria.postgresql.org; Fri, 10 Sep 2021 06:39:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mOaC1-0008AV-Jk for pgsql-committers@arkaria.postgresql.org; Fri, 10 Sep 2021 06:39:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOaC1-0008AM-Dy for pgsql-committers@lists.postgresql.org; Fri, 10 Sep 2021 06:39:21 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOaBy-0001lh-SL for pgsql-committers@lists.postgresql.org; Fri, 10 Sep 2021 06:39:20 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOaBy-0003wF-LY for pgsql-committers@lists.postgresql.org; Fri, 10 Sep 2021 06:39:18 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mOaBy-0006mH-1P for pgsql-committers@lists.postgresql.org; Fri, 10 Sep 2021 06:39:18 +0000 Content-Type: multipart/mixed; boundary="===============4290339038884648218==" MIME-Version: 1.0 From: Noah Misch To: pgsql-committers@lists.postgresql.org Subject: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 10 Sep 2021 06:39:18 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4290339038884648218== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmV2b2tlIFBVQkxJQyBDUkVBVEUgZnJvbSBwdWJsaWMgc2NoZW1hLCBub3cgb3duZWQgYnkgcGdf ZGF0YWJhc2Vfb3duZXIuCgpUaGlzIHN3aXRjaGVzIHRoZSBkZWZhdWx0IEFDTCB0byB3aGF0IHRo ZSBkb2N1bWVudGF0aW9uIGhhcyByZWNvbW1lbmRlZApzaW5jZSBDVkUtMjAxOC0xMDU4LiAgVXBn cmFkZXMgd2lsbCBjYXJyeSBmb3J3YXJkIGFueSBvbGQgb3duZXJzaGlwIGFuZApBQ0wuICBTaXRl cyB0aGF0IGRlY2xpbmVkIHRoZSAyMDE4IHJlY29tbWVuZGF0aW9uIHNob3VsZCB0YWtlIGEgZnJl c2gKbG9vay4gIFJlY2lwZXMgZm9yIGNvbW1pc3Npb25pbmcgYSBuZXcgZGF0YWJhc2UgY2x1c3Rl ciBmcm9tIHNjcmF0Y2ggbWF5Cm5lZWQgdG8gY3JlYXRlIGEgc2NoZW1hLCBncmFudCBtb3JlIHBy aXZpbGVnZXMsIGV0Yy4gIE91dC1vZi10cmVlIHRlc3QKc3VpdGVzIG1heSByZXF1aXJlIHN1Y2gg dXBkYXRlcy4KClJldmlld2VkIGJ5IFBldGVyIEVpc2VudHJhdXQuCgpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tLzIwMjAxMDMxMTYzNTE4LkdCNDAzOTEzM0ByZmQubGVhZGJvYXQuY29t CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYjA3M2MzY2NkMDZlNGNiODQ1ZTEyMTM4N2E0M2ZhYThj NjhhN2I2MgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wb3N0Z3Jlc19m ZHcvZXhwZWN0ZWQvcG9zdGdyZXNfZmR3Lm91dCB8ICAyICstCmNvbnRyaWIvcG9zdGdyZXNfZmR3 L3NxbC9wb3N0Z3Jlc19mZHcuc3FsICAgICAgfCAgMiArLQpkb2Mvc3JjL3NnbWwvZGRsLnNnbWwg ICAgICAgICAgICAgICAgICAgICAgICAgIHwgNTYgKysrKysrKysrKysrKystLS0tLS0tLS0tLS0K ZG9jL3NyYy9zZ21sL3VzZXItbWFuYWcuc2dtbCAgICAgICAgICAgICAgICAgICB8IDE5ICsrKyst LS0tLQpzcmMvYmluL2luaXRkYi9pbml0ZGIuYyAgICAgICAgICAgICAgICAgICAgICAgIHwgIDMg Ky0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuYyAgICAgICAgICAgICAgICAgICAgICB8IDI4ICsr KysrKysrLS0tLS0Kc3JjL2Jpbi9wZ19kdW1wL3QvMDAyX3BnX2R1bXAucGwgICAgICAgICAgICAg ICB8IDE5ICsrKystLS0tLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAg ICAgICAgIHwgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19uYW1lc3BhY2UuZGF0ICAgICAg ICAgICB8ICAyICstCnNyYy9wbC9wbHBlcmwvZXhwZWN0ZWQvcGxwZXJsX3NldHVwLm91dCAgICAg ICAgfCAgNCArKwpzcmMvcGwvcGxwZXJsL3NxbC9wbHBlcmxfc2V0dXAuc3FsICAgICAgICAgICAg IHwgIDQgKysKc3JjL3Rlc3QvcmVncmVzcy9pbnB1dC90YWJsZXNwYWNlLnNvdXJjZSAgICAgICB8 ICA1ICsrLQpzcmMvdGVzdC9yZWdyZXNzL291dHB1dC90YWJsZXNwYWNlLnNvdXJjZSAgICAgIHwg IDQgKy0KMTMgZmlsZXMgY2hhbmdlZCwgODYgaW5zZXJ0aW9ucygrKSwgNjQgZGVsZXRpb25zKC0p Cgo= --===============4290339038884648218==--