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 1oQ9ZT-0007N2-0Z for pgsql-committers@arkaria.postgresql.org; Mon, 22 Aug 2022 15:42:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oQ9ZR-0006D0-RT for pgsql-committers@arkaria.postgresql.org; Mon, 22 Aug 2022 15:42:33 +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 1oQ9ZR-0006Cq-6J for pgsql-committers@lists.postgresql.org; Mon, 22 Aug 2022 15:42:33 +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 1oQ9ZO-0003oc-70 for pgsql-committers@lists.postgresql.org; Mon, 22 Aug 2022 15:42:32 +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=vXbdd4Bfjmn9r3OdQBFvw8H4MpXbusttCYPmq26gp7c=; b=yW0KAt3yuLunHSY7QK1PahBEP7 6cnPEkN3oKMN2il4QqIyRxCAaJKNM6JXr2oPr8TR5YKQfREVnvoil6xz8eWAF9EQTfvdl/uxLmRsf ULlAmJ+J4nXnoPIt0t8nhKTpmPl1FIv0yX69pPFZzUu5q/9jUp6tCrCtkWGW373C1CwVGZCiKSqE0 Wp9kveNLwzfeNWcf3IWjIslyW4h6thF/D5JLlXWZpV4+/FRMJ9vGLB8zRgtRCHUZZnA/5c+/kW5F6 2Ot6bPOfoRmCsoUYRKSscqhbZ0Yc8+sYPpFEMWYEojj1eutsStzsqtJJji2nncRmMk+FZRT4kEejW XB6tkguQ==; 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 1oQ9ZN-00081x-SC for pgsql-committers@lists.postgresql.org; Mon, 22 Aug 2022 15:42:29 +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 1oQ9ZM-000iLV-2R for pgsql-committers@lists.postgresql.org; Mon, 22 Aug 2022 15:42:29 +0000 Content-Type: multipart/mixed; boundary="===============6183257969220292337==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Make role grant system more consistent with other privileges. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 22 Aug 2022 15:42:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6183257969220292337== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 TWFrZSByb2xlIGdyYW50IHN5c3RlbSBtb3JlIGNvbnNpc3RlbnQgd2l0aCBvdGhlciBwcml2aWxl Z2VzLgoKUHJldmlvdXNseSwgbWVtYmVyc2hpcCBvZiByb2xlIEEgaW4gcm9sZSBCIGNvdWxkIGJl IHJlY29yZGVkIGluIHRoZQpjYXRhbG9nIHRhYmxlcyBvbmx5IG9uY2UuIFRoaXMgbWVhbnQgdGhh dCBhIG5ldyBncmFudCBvZiByb2xlIEEgdG8Kcm9sZSBCIHdvdWxkIG92ZXJ3cml0ZSB0aGUgcHJl dmlvdXMgZ3JhbnQuIEZvciBvdGhlciBvYmplY3QgdHlwZXMsIGEKbmV3IGdyYW50IG9mIHBlcm1p c3Npb24gb24gYW4gb2JqZWN0IC0gaW4gdGhpcyBjYXNlIHJvbGUgQSAtIGV4aXN0cwphbG9uZyBz aWRlIHRoZSBleGlzdGluZyBncmFudCBwcm92aWRlZCB0aGF0IHRoZSBncmFudG9yIGlzIGRpZmZl cmVudC4KRWl0aGVyIGdyYW50IGNhbiBiZSByZXZva2VkIGluZGVwZW5kZW50bHkgb2YgdGhlIG90 aGVyLCBhbmQKcGVybWlzc2lvbnMgcmVtYWluIHNvIGxvbmcgYXMgYXQgbGVhc3Qgb25lIGdyYW50 IHJlbWFpbnMuIE1ha2Ugcm9sZQpncmFudHMgd29yayBzaW1pbGFybHkuCgpQcmV2aW91c2x5LCB3 aGVuIGdyYW50aW5nIG1lbWJlcnNoaXAgaW4gYSByb2xlLCB0aGUgc3VwZXJ1c2VyIGNvdWxkCnNw ZWNpZnkgYW55IHJvbGUgd2hhdHNvZXZlciBhcyB0aGUgZ3JhbnRvciwgYnV0IGZvciBvdGhlciBv YmplY3QgdHlwZXMsCnRoZSBncmFudG9yIG9mIHJlY29yZCBtdXN0IGJlIGVpdGhlciB0aGUgb3du ZXIgb2YgdGhlIG9iamVjdCwgb3IgYQpyb2xlIHRoYXQgY3VycmVudGx5IGhhcyBwcml2aWxlZ2Vz IHRvIHBlcmZvcm0gYSBzaW1pbGFyIEdSQU5ULgpJbXBsZW1lbnQgdGhlIHNhbWUgc2NoZW1lIGZv ciByb2xlIGdyYW50cywgdHJlYXRpbmcgdGhlIGJvb3RzdHJhcApzdXBlcnVzZXIgYXMgdGhlIHJv bGUgb3duZXIgc2luY2Ugcm9sZXMgZG8gbm90IGhhdmUgb3duZXJzLiBUaGlzIG1lYW5zCnRoYXQg YXR0ZW1wdGluZyB0byByZXZva2UgYSBncmFudCwgb3IgYWRtaW4gb3B0aW9uIG9uIGEgZ3JhbnQs IGNhbiBub3cKZmFpbCBpZiB0aGVyZSBhcmUgZGVwZW5kZW50IHByaXZpbGVnZXMsIGFuZCB0aGF0 IENBU0NBREUgY2FuIGJlIHVzZWQKdG8gcmV2b2tlIHRoZXNlLiBJdCBhbHNvIG1lYW5zIHRoYXQg eW91IGNhbid0IGdyYW50IEFETUlOIE9QVElPTiBvbgphIHJvbGUgYmFjayB0byBhIHVzZXIgd2hv IGdyYW50ZWQgaXQgZGlyZWN0bHkgb3IgaW5kaXJlY3RseSB0byB5b3UsCnNpbWlsYXIgdG8gaG93 IHlvdSBjYW4ndCBnaXZlIFdJVEggR1JBTlQgT1BUSU9OIG9uIGEgcHJpdmlsZWdlIGJhY2sKdG8g YSByb2xlIHdoaWNoIGdyYW50ZWQgaXQgZGlyZWN0bHkgb3IgaW5kaXJlY3RseSB0byB5b3UuCgpQ cmV2aW91c2x5LCBvbmx5IHRoZSBzdXBlcnVzZXIgY291bGQgc3BlY2lmeSBHUkFOVEVEIEJZIHdp dGggYSB1c2VyCm90aGVyIHRoYW4gdGhlIGN1cnJlbnQgdXNlci4gUmVsYXggdGhhdCBydWxlIHRv IGFsbG93IHRoZSBncmFudG9yCnRvIGJlIGFueSByb2xlIHdob3NlIHByaXZpbGVnZXMgdGhlIGN1 cnJlbnQgdXNlciBwb3NzZXNlcy4gVGhpcwpkb2Vzbid0IGltcHJvdmUgY29tcGF0aWJpbGl0eSB3 aXRoIHdoYXQgd2UgZG8gZm9yIG90aGVyIG9iamVjdCB0eXBlcywKd2hlcmUgc3VwcG9ydCBmb3Ig R1JBTlRFRCBCWSBpcyBlbnRpcmVseSB2ZXN0aWdpYWwsIGJ1dCBpdCBtYWtlcyB0aGlzCmZlYXR1 cmUgbW9yZSB1c2FibGUgYW5kIHNlZW1zIHRvIG1ha2Ugc2Vuc2UgdG8gY2hhbmdlIGF0IHRoZSBz YW1lIHRpbWUKd2UncmUgY2hhbmdpbmcgcmVsYXRlZCBiZWhhdmlvcnMuCgpBbG9uZyB0aGUgd2F5 LCBmaXggIkFMVEVSIEdST1VQIGdyb3VwX25hbWUgQUREIFVTRVIgdXNlcl9uYW1lIiB0bwpyZXF1 aXJlIHRoZSBzYW1lIHByaXZpbGVnZXMgYXMgIkdSQU5UIGdyb3VwX25hbWUgVE8gdXNlcl9uYW1l Ii4KUHJldmlvdXNseSwgQ1JFQVRFUk9MRSBwcml2aWxlZ2VzIHdlcmUgc3VmZmljaWVudCBmb3Ig ZWl0aGVyLCBidXQKb25seSB0aGUgZm9ybWVyIGZvcm0gd2FzIHBlcm1pc3NpYmxlIHdpdGggQURN SU4gT1BUSU9OIG9uIHRoZSByb2xlLgpOb3csIGVpdGhlciBDUkVBVEVST0xFIG9yIEFETUlOIE9Q VElPTiBvbiB0aGUgcm9sZSBzdWZmaWNlcyBmb3IKZWl0aGVyIHNwZWxsaW5nLgoKUGF0Y2ggYnkg bWUsIHJldmlld2VkIGJ5IFN0ZXBoZW4gRnJvc3QuCgpEaXNjdXNzaW9uOiBodHRwOi8vcG9zdGdy LmVzL20vQ0ErVGdtb2FGci1SWmVRK1dvUTVuS1B2OTdvVDkrYURnS19hNStxV0hTZ2JEc01wMVZn QG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0 dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvY2U2YjY3MmU0NDU1ODIwYTAz NDgyMTRiZTBkYTFhMDI0YzNmNjE5ZgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9j L3NyYy9zZ21sL3JlZi9hbHRlcl9ncm91cC5zZ21sICAgICAgICAgfCAgIDYgKy0KZG9jL3NyYy9z Z21sL3JlZi9ncmFudC5zZ21sICAgICAgICAgICAgICAgfCAgMTIgKy0KZG9jL3NyYy9zZ21sL3Jl Zi9yZXZva2Uuc2dtbCAgICAgICAgICAgICAgfCAgMTIgKy0Kc3JjL2JhY2tlbmQvY29tbWFuZHMv dXNlci5jICAgICAgICAgICAgICAgfCA1NjUgKysrKysrKysrKysrKysrKysrKysrKysrKystLS0t CnNyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkgICAgICAgICAgICAgICAgIHwgICAyICsKc3JjL2Jh Y2tlbmQvdXRpbHMvYWR0L2FjbC5jICAgICAgICAgICAgICAgfCAgNDcgKystCnNyYy9iYWNrZW5k L3V0aWxzL2NhY2hlL3N5c2NhY2hlLmMgICAgICAgIHwgICA4ICstCnNyYy9iaW4vcGdfZHVtcC9w Z19kdW1wYWxsLmMgICAgICAgICAgICAgIHwgMTc3ICsrKysrKysrKy0Kc3JjL2luY2x1ZGUvY2F0 YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9w Z19hdXRoX21lbWJlcnMuaCAgICAgfCAgIDQgKy0Kc3JjL2luY2x1ZGUvdXRpbHMvYWNsLmggICAg ICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NyZWF0ZV9y b2xlLm91dCB8ICAxNiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3ByaXZpbGVnZXMub3V0 ICB8ICA3MyArKystCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NyZWF0ZV9yb2xlLnNxbCAgICAgIHwg ICA3ICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3ByaXZpbGVnZXMuc3FsICAgICAgIHwgIDQyICsr LQoxNSBmaWxlcyBjaGFuZ2VkLCA4MzQgaW5zZXJ0aW9ucygrKSwgMTQwIGRlbGV0aW9ucygtKQoK --===============6183257969220292337==--