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 1nYu9z-0002TT-NC for pgsql-committers@arkaria.postgresql.org; Mon, 28 Mar 2022 18:32:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nYu8z-0001Fg-TL for pgsql-committers@arkaria.postgresql.org; Mon, 28 Mar 2022 18:31:09 +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 1nYu8z-0001FX-IN for pgsql-committers@lists.postgresql.org; Mon, 28 Mar 2022 18:31:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nYu8v-0005Kt-6o for pgsql-committers@lists.postgresql.org; Mon, 28 Mar 2022 18:31:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=fmjTcmjq9b7uZRnRNxflVOfrTZ8OWH12Zutp0/wH9jo=; b=5B9XrPTg5p9i7+HXtEb2rQCCXL QJLlJ+tx/o5xKRrZ1nDExvGGOfMGizRb3ZpyD1CiKL1NxP3BK5Mc+DNP1tp0C8mGQCfSIOO9xsabb AznQzg8KiVGqqah4BPpEVBOkNeIEZ8CQY/9oJWxP1MXi9RRsA5f/7bzUYh2zKaJbgdalyskFSkVz2 w7Db203EpwGrg6bbgr0yJ5OCDFZXqS86JbTil157f6PcCRcGevvrz8DDJMaQjGARK+uZHsjyF4I5k 9NU+i/SnZOVTlBq6qriTQRM1dwHvaCQo4oel407Ws8Q9i7r9GN9pwKKRve2hlBNrNv7gCl/kAl7T2 6qXU00UA==; 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 1nYu8t-0001TO-Nf for pgsql-committers@lists.postgresql.org; Mon, 28 Mar 2022 18:31:03 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1nYu8r-001n7w-RG for pgsql-committers@lists.postgresql.org; Mon, 28 Mar 2022 18:31:02 +0000 Content-Type: multipart/mixed; boundary="===============0930684077740951098==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Remove the ability of a role to administer itself. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 28 Mar 2022 18:31:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0930684077740951098== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVtb3ZlIHRoZSBhYmlsaXR5IG9mIGEgcm9sZSB0byBhZG1pbmlzdGVyIGl0c2VsZi4KCkNvbW1p dCBmOWZkMTc2NDYxNWVkNWQ4NWZhYjcwM2IwZmZiMGMzMjNmZTdkZmQ1IGVmZmVjdGl2ZWx5IGdh dmUKZXZlcnkgcm9sZSBBRE1JTiBPUFRJT04gb24gaXRzZWxmLiBIb3dldmVyLCB0aGlzIGFwcGVh cnMgdG8gYmUKc29tZXRoaW5nIHRoYXQgaGFwcGVuZWQgYWNjaWRlbnRhbGx5IGFzIGEgcmVzdWx0 IG9mIHJlZmFjdG9yaW5nCndvcmsgcmF0aGVyIHRoYW4gYW4gaW50ZW50aW9uYWwgZGVjaXNpb24u IEFsbW9zdCBhIGRlY2FkZSBsYXRlciwKaXQgd2FzIGRpc2NvdmVyZWQgdGhhdCB0aGlzIHdhcyBh IHNlY3VyaXR5IHZ1bG5lcmFiaWxpdHkuIEFzIGEKcmVzdWx0LCBjb21taXQgZmVhMTY0YTcyYTdi ZmQ1MGQ3N2JhNWZiNDE4ZDM1N2Y4ZjJiYjdkMCByZXN0cmljdGVkCnRoaXMgaW1wbGljaXQgQURN SU4gT1BUSU9OIHByaXZpbGVnZSB0byBiZSBleGVyY2lzYWJsZSBvbmx5IHdoZW4KdGhlIHJvbGUg YmVpbmcgYWRtaW5pc3RlcmVkIGlzIHRoZSBzYW1lIGFzIHRoZSBzZXNzaW9uIHVzZXIgYW5kCndo ZW4gbm8gc2VjdXJpdHktcmVzdHJpY3RlZCBvcGVyYXRpb24gaXMgaW4gcHJvZ3Jlc3MuIFRoYXQK Y29tbWl0IGFsc28gZG9jdW1lbnRlZCB0aGUgZXhpc3RlbmNlIG9mIHRoaXMgaW1wbGljaXQgcHJp dmlsZWdlCmZvciB3aGF0IHNlZW1zIHRvIGJlIHRoZSBmaXJzdCB0aW1lLgoKVGhlIGVmZmVjdCBv ZiB0aGUgcHJpdmlsZWdlIGlzIHRvIGFsbG93IGEgbG9naW4gcm9sZSB0byBncmFudAp0aGUgcHJp dmlsZWdlcyBvZiB0aGF0IHJvbGUsIGFuZCBvcHRpb25hbGx5IEFETUlOIE9QVElPTiBvbiBpdCwK dG8gc29tZSBvdGhlciByb2xlLiBUaGF0J3MgYW4gdW51c3VhbCB0aGluZyB0byBkbywgYmVjYXVz ZSBnZW5lcmFsbHkKbWVtYmVyc2hpcCBpcyBncmFudGVkIGluIHJvbGVzIHVzZWQgYXMgZ3JvdXBz LCByYXRoZXIgdGhhbiByb2xlcwp1c2VkIGFzIHVzZXJzLiBUaGVyZWZvcmUsIGl0IGRvZXMgbm90 IHNlZW0gbGlrZWx5IHRoYXQgcmVtb3ZpbmcKdGhlIHByaXZpbGVnZSB3aWxsIGJyZWFrIHRoaW5n cyBmb3IgbWFueSBQb3N0Z3JlU1FMIHVzZXJzLgoKSG93ZXZlciwgaXQgd2lsbCBtYWtlIGl0IGVh c2llciB0byByZWFzb24gYWJvdXQgdGhlIHBlcm1pc3Npb25zCnN5c3RlbS4gVGhpcyBpcyB0aGUg b25seSBjYXNlIHdoZXJlIGEgdXNlciB3aG8gaGFzIG5vdCBiZWVuIGdpdmVuIGFueQpzcGVjaWFs IHBlcm1pc3Npb24gKHN1cGVydXNlciwgb3IgQURNSU4gT1BUSU9OIG9uIHNvbWUgcm9sZSkgY2Fu Cm1vZGlmeSByb2xlIG1lbWJlcnNoaXAsIHNvIHJlbW92aW5nIGl0IG1ha2VzIHRoaW5ncyBtb3Jl IGNvbnNpc3RlbnQuCkZvciBleGFtcGxlLCBpZiBhIHN1cGVydXNlciBzZXRzIHVwIHJvbGUgQSBh bmQgQiBhbmQgZ3JhbnRzIEEgdG8gQgpidXQgbm8gb3RoZXIgcHJpdmlsZWdlcyB0byBhbnlvbmUs IHNoZSBjYW4gbm93IGJlIHN1cmUgdGhhdCBubyBvbmUKZWxzZSB3aWxsIGJlIGFibGUgdG8gcmV2 b2tlIHRoYXQgZ3JhbnQuIFdpdGhvdXQgdGhpcyBjaGFuZ2UsIHRoYXQKd291bGQgaGF2ZSBiZWVu IHRydWUgb25seSBpZiBBIHdhcyBhIG5vbi1sb2dpbiByb2xlLgoKUGF0Y2ggYnkgbWUuIFJldmll d2VkIGJ5IFRvbSBMYW5lIGFuZCBTdGVwaGVuIEZyb3N0LgoKRGlzY3Vzc2lvbjogaHR0cDovL3Bv c3Rnci5lcy9tL0NBK1RnbW9hd2R0MDNrYkErZE55QmNOV0pwUnh1MGY0WD02OVkzK0RrWFhacW13 TURMZ0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzc5ZGU5ODQyYWIwMzI1 OTMyNWVlNDA1NWZiMGE3ZWJkMmU0MzcyZmYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CmRvYy9zcmMvc2dtbC9yZWYvZ3JhbnQuc2dtbCAgICAgICAgICAgICAgfCAgOSArKysrLS0tLQpz cmMvYmFja2VuZC9jb21tYW5kcy91c2VyLmMgICAgICAgICAgICAgIHwgIDUgLS0tLS0Kc3JjL2Jh Y2tlbmQvdXRpbHMvYWR0L2FjbC5jICAgICAgICAgICAgICB8IDM4ICsrLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcHJpdmlsZWdlcy5vdXQg fCAgOCArLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3ByaXZpbGVnZXMuc3FsICAgICAgfCAg NiArLS0tLQo1IGZpbGVzIGNoYW5nZWQsIDggaW5zZXJ0aW9ucygrKSwgNTggZGVsZXRpb25zKC0p Cgo= --===============0930684077740951098==--