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 1n7uD4-0000Yd-QC for pgsql-docs@arkaria.postgresql.org; Thu, 13 Jan 2022 07:07:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n7uD3-0007k5-Cj for pgsql-docs@arkaria.postgresql.org; Thu, 13 Jan 2022 07:07:45 +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 1n7uD3-0007jw-56 for pgsql-docs@lists.postgresql.org; Thu, 13 Jan 2022 07:07:45 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n7uD0-0001HV-5a for pgsql-docs@lists.postgresql.org; Thu, 13 Jan 2022 07:07:44 +0000 Received: from oss.nttdata.com (localhost [127.0.0.1]) by oss.nttdata.com (Postfix) with ESMTPA id 5AB28602A4; Thu, 13 Jan 2022 16:07:38 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.4 at oss.nttdata.com MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_2983d939afcd91423bd14d9e37580c07" Content-Transfer-Encoding: 7bit Date: Thu, 13 Jan 2022 16:07:38 +0900 From: Shinya Kato To: Laurenz Albe Cc: pgsql-docs@lists.postgresql.org Subject: Re: Question about role attributes docs In-Reply-To: References: <1ecdb1ff78e9b03dfce37e85eaca725a@oss.nttdata.com> User-Agent: Roundcube Webmail/1.4.11 Message-ID: <746e739062e232ce42a3a8d07ecac1c5@oss.nttdata.com> X-Sender: Shinya11.Kato@oss.nttdata.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=_2983d939afcd91423bd14d9e37580c07 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed On 2022-01-12 02:07, Laurenz Albe wrote: > On Tue, 2022-01-11 at 16:40 +0900, Shinya Kato wrote: >> I have a question about the documentation on ROLE. >> >> According to [1], INHERIT and BYPASSRLS can be specified when >> executing >> the CREATE ROLE command. However, there is no such description in Role >> Attributes in [2]. Are these concepts different from Role Attributes? >> Or >> are they just not documented? If they need to be documented, I'll >> create >> a patch. >> >> [1] https://www.postgresql.org/docs/devel/sql-createrole.html >> [2] https://www.postgresql.org/docs/devel/role-attributes.html > > I think that is indeed an omission, and adding documentation would be a > good idea. Thanks! I created the patch, and attached it. > On the other hand, a lot of that information is more or less > a duplicate of the CREATE ROLE documentation. I wonder if the latter > page could be removed altogether. I think there is certainly a lot of overlap. However, I think that the SQL commands page and the database roles page should exist separately, and should be maintained as they are because there are parts that do not overlap (for example, IN ROLE and ADMIN). -- Regards, -- Shinya Kato Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION --=_2983d939afcd91423bd14d9e37580c07 Content-Transfer-Encoding: base64 Content-Type: text/x-diff; name=add-role-attributes-to-docs.patch Content-Disposition: attachment; filename=add-role-attributes-to-docs.patch; size=2101 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC91c2VyLW1hbmFnLnNnbWwgYi9kb2Mvc3JjL3NnbWwv dXNlci1tYW5hZy5zZ21sCmluZGV4IDkwNjdiZTFkOWMuLmNmNmFkYjM0MzYgMTAwNjQ0Ci0tLSBh L2RvYy9zcmMvc2dtbC91c2VyLW1hbmFnLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3VzZXItbWFu YWcuc2dtbApAQCAtMjM2LDYgKzIzNiw0MiBAQCBDUkVBVEUgVVNFUiA8cmVwbGFjZWFibGU+bmFt ZTwvcmVwbGFjZWFibGU+OwogICAgICAgIDwvcGFyYT4KICAgICAgIDwvbGlzdGl0ZW0+CiAgICAg IDwvdmFybGlzdGVudHJ5PgorCisgICAgIDx2YXJsaXN0ZW50cnk+CisgICAgICA8dGVybT5pbmhl cml0YW5jZSBvZiBwcml2aWxlZ2VzPGluZGV4dGVybT48cHJpbWFyeT5yb2xlPC9wcmltYXJ5Pjxz ZWNvbmRhcnk+cHJpdmlsZWdlIHRvIGluaGVyaXQ8L3NlY29uZGFyeT48L2luZGV4dGVybT48L3Rl cm0+CisgICAgICA8bGlzdGl0ZW0+CisgICAgICAgPHBhcmE+CisgICAgICAgIEEgcm9sZSBpcyBu ZWVkZWQgdG8gcGVybWlzc2lvbiB0byBpbmhlcml0IHByaXZpbGVnZXMgb2Ygcm9sZXMgaXQgaXMg YSBtZW1iZXIgb2YuCisgICAgICAgIChleGNlcHQgZm9yIHN1cGVydXNlcnMsIHNpbmNlIHRob3Nl IGJ5cGFzcyBhbGwgcGVybWlzc2lvbiBjaGVja3MpLgorICAgICAgICBJZiBub3Qgc3BlY2lmaWVk LCA8bGl0ZXJhbD5JTkhFUklUPC9saXRlcmFsPiBpcyB0aGUgZGVmYXVsdCwgc28gdG8gY3JlYXRl IHN1Y2ggYSByb2xlLCB1c2UgZWl0aGVyOgorPHByb2dyYW1saXN0aW5nPgorQ1JFQVRFIFJPTEUg PHJlcGxhY2VhYmxlPm5hbWU8L3JlcGxhY2VhYmxlPiBJTkhFUklUOworQ1JFQVRFIFJPTEUgPHJl cGxhY2VhYmxlPm5hbWU8L3JlcGxhY2VhYmxlPjsKKzwvcHJvZ3JhbWxpc3Rpbmc+CisgICAgICAg PC9wYXJhPgorICAgICAgPC9saXN0aXRlbT4KKyAgICAgPC92YXJsaXN0ZW50cnk+CisKKyAgICAg PHZhcmxpc3RlbnRyeT4KKyAgICAgIDx0ZXJtPmJ5cGFzcyByb3ctbGV2ZWwgc2VjdXJpdHk8aW5k ZXh0ZXJtPjxwcmltYXJ5PnJvbGU8L3ByaW1hcnk+PHNlY29uZGFyeT5wcml2aWxlZ2UgdG8gYnlw YXNzPC9zZWNvbmRhcnk+PC9pbmRleHRlcm0+PC90ZXJtPgorICAgICAgPGxpc3RpdGVtPgorICAg ICAgIDxwYXJhPgorICAgICAgICBBIHJvbGUgbXVzdCBiZSBleHBsaWNpdGx5IGdpdmVuIHBlcm1p c3Npb24gdG8gYnlwYXNzIHJvdy1sZXZlbCBzZWN1cml0eSAoUkxTKSBwb2xpY3kuCisgICAgICAg IChleGNlcHQgZm9yIHN1cGVydXNlcnMsIHNpbmNlIHRob3NlIGJ5cGFzcyBhbGwgcGVybWlzc2lv biBjaGVja3MpLgorICAgICAgICBUbyBjcmVhdGUgc3VjaCBhIHJvbGUsIHVzZSA8bGl0ZXJhbD5D UkVBVEUgUk9MRSA8cmVwbGFjZWFibGU+bmFtZTwvcmVwbGFjZWFibGU+IEJZUEFTU1JMUzwvbGl0 ZXJhbD4uCisgICAgICAgPC9wYXJhPgorICAgICAgPC9saXN0aXRlbT4KKyAgICAgPC92YXJsaXN0 ZW50cnk+CisKKyAgICAgPHZhcmxpc3RlbnRyeT4KKyAgICAgIDx0ZXJtPmNvbm5lY3Rpb24gbGlt aXQ8aW5kZXh0ZXJtPjxwcmltYXJ5PnJvbGU8L3ByaW1hcnk+PHNlY29uZGFyeT5wcml2aWxlZ2Ug dG8gbGltaXQgY29ubmVjdGlvbjwvc2Vjb25kYXJ5PjwvaW5kZXh0ZXJtPjwvdGVybT4KKyAgICAg IDxsaXN0aXRlbT4KKyAgICAgICA8cGFyYT4KKyAgICAgICAgQ29ubmVjdGlvbiBsaW1pdCBjYW4g c3BlY2lmeSBob3cgbWFueSBjb25jdXJyZW50IGNvbm5lY3Rpb25zIGEgcm9sZSBjYW4gbWFrZS4K KyAgICAgICAgLTEgKHRoZSBkZWZhdWx0KSBtZWFucyBubyBsaW1pdC4gVG8gY3JlYXRlIHN1Y2gg YSByb2xlLCB1c2UgPGxpdGVyYWw+Q1JFQVRFIFJPTEUgPHJlcGxhY2VhYmxlPm5hbWU8L3JlcGxh Y2VhYmxlPiBDT05ORUNUSU9OIExJTUlUPHJlcGxhY2VhYmxlPiBjb25ubGltaXQ8L3JlcGxhY2Vh YmxlPiBMT0dJTjwvbGl0ZXJhbD4uCisgICAgICAgPC9wYXJhPgorICAgICAgPC9saXN0aXRlbT4K KyAgICAgPC92YXJsaXN0ZW50cnk+CiAgICAgPC92YXJpYWJsZWxpc3Q+CiAKICAgICBBIHJvbGUn cyBhdHRyaWJ1dGVzIGNhbiBiZSBtb2RpZmllZCBhZnRlciBjcmVhdGlvbiB3aXRoCg== --=_2983d939afcd91423bd14d9e37580c07--