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 1neVuq-0006kp-BU for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Apr 2022 05:51:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1neVup-0007zF-4R for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Apr 2022 05:51:43 +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 1neVuo-0007z6-RD for pgsql-hackers@lists.postgresql.org; Wed, 13 Apr 2022 05:51:42 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1neVum-0004ym-Ao for pgsql-hackers@postgresql.org; Wed, 13 Apr 2022 05:51:42 +0000 Received: from oss.nttdata.com (localhost [127.0.0.1]) by oss.nttdata.com (Postfix) with ESMTPA id 53D6B611B4 for ; Wed, 13 Apr 2022 14:51:35 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.5 at oss.nttdata.com MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_0ec1189d168f87550ad0299a9f301384" Content-Transfer-Encoding: 7bit Date: Wed, 13 Apr 2022 14:51:35 +0900 From: Shinya Kato To: pgsql-hackers@postgresql.org Subject: Add --{no-,}bypassrls flags to createuser User-Agent: Roundcube Webmail/1.4.11 Message-ID: <69a9851035cf0f0477bcc5d742b031a3@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 --=_0ec1189d168f87550ad0299a9f301384 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Hi, Add --{no-,}bypassrls flags to createuser. The following is an example of execution. -- $ createuser a --bypassrls $ psql -c "\du a" List of roles Role name | Attributes | Member of -----------+------------+----------- a | Bypass RLS | {} -- Do you think? Regards, -- Shinya Kato Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION --=_0ec1189d168f87550ad0299a9f301384 Content-Transfer-Encoding: base64 Content-Type: text/x-diff; name=v1-add-bypassrls-flag-to-createuser.patch Content-Disposition: attachment; filename=v1-add-bypassrls-flag-to-createuser.patch; size=3344 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRldXNlci5zZ21sIGIvZG9jL3NyYy9z Z21sL3JlZi9jcmVhdGV1c2VyLnNnbWwKaW5kZXggMTc1NzllNTBhZi4uNmMyZWUxZTBjNiAxMDA2 NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGV1c2VyLnNnbWwKKysrIGIvZG9jL3NyYy9z Z21sL3JlZi9jcmVhdGV1c2VyLnNnbWwKQEAgLTI5MCw2ICsyOTAsMjggQEAgUG9zdGdyZVNRTCBk b2N1bWVudGF0aW9uCiAgICAgICA8L2xpc3RpdGVtPgogICAgICA8L3Zhcmxpc3RlbnRyeT4KIAor ICAgICA8dmFybGlzdGVudHJ5PgorICAgICAgPHRlcm0+PG9wdGlvbj4tLWJ5cGFzc3Jsczwvb3B0 aW9uPjwvdGVybT4KKyAgICAgIDxsaXN0aXRlbT4KKyAgICAgICA8cGFyYT4KKyAgICAgICAgVGhl IG5ldyB1c2VyIHdpbGwgaGF2ZSB0aGUgPGxpdGVyYWw+QllQQVNTUkxTPC9saXRlcmFsPiBwcml2 aWxlZ2UsCisgICAgICAgIHdoaWNoIGlzIGRlc2NyaWJlZCBtb3JlIGZ1bGx5IGluIHRoZSBkb2N1 bWVudGF0aW9uIGZvciA8eHJlZgorICAgICAgICBsaW5rZW5kPSJzcWwtY3JlYXRlcm9sZSIvPi4K KyAgICAgICA8L3BhcmE+CisgICAgICA8L2xpc3RpdGVtPgorICAgICA8L3Zhcmxpc3RlbnRyeT4K KworICAgICA8dmFybGlzdGVudHJ5PgorICAgICAgPHRlcm0+PG9wdGlvbj4tLW5vLWJ5cGFzc3Js czwvb3B0aW9uPjwvdGVybT4KKyAgICAgIDxsaXN0aXRlbT4KKyAgICAgICA8cGFyYT4KKyAgICAg ICAgVGhlIG5ldyB1c2VyIHdpbGwgbm90IGhhdmUgdGhlIDxsaXRlcmFsPkJZUEFTU1JMUzwvbGl0 ZXJhbD4KKyAgICAgICAgcHJpdmlsZWdlLCB3aGljaCBpcyBkZXNjcmliZWQgbW9yZSBmdWxseSBp biB0aGUgZG9jdW1lbnRhdGlvbiBmb3IgPHhyZWYKKyAgICAgICAgbGlua2VuZD0ic3FsLWNyZWF0 ZXJvbGUiLz4uCisgICAgICAgPC9wYXJhPgorICAgICAgPC9saXN0aXRlbT4KKyAgICAgPC92YXJs aXN0ZW50cnk+CisKICAgICAgPHZhcmxpc3RlbnRyeT4KICAgICAgICA8dGVybT48b3B0aW9uPi0/ PC9vcHRpb24+PC90ZXJtPgogICAgICAgIDx0ZXJtPjxvcHRpb24+LS1oZWxwPC9vcHRpb24+PC90 ZXJtPgpkaWZmIC0tZ2l0IGEvc3JjL2Jpbi9zY3JpcHRzL2NyZWF0ZXVzZXIuYyBiL3NyYy9iaW4v c2NyaXB0cy9jcmVhdGV1c2VyLmMKaW5kZXggYmZiYTBkMDlkMS4uNWIzNjNiNmY1NCAxMDA2NDQK LS0tIGEvc3JjL2Jpbi9zY3JpcHRzL2NyZWF0ZXVzZXIuYworKysgYi9zcmMvYmluL3NjcmlwdHMv Y3JlYXRldXNlci5jCkBAIC00OCw2ICs0OCw4IEBAIG1haW4oaW50IGFyZ2MsIGNoYXIgKmFyZ3Zb XSkKIAkJeyJyZXBsaWNhdGlvbiIsIG5vX2FyZ3VtZW50LCBOVUxMLCAxfSwKIAkJeyJuby1yZXBs aWNhdGlvbiIsIG5vX2FyZ3VtZW50LCBOVUxMLCAyfSwKIAkJeyJpbnRlcmFjdGl2ZSIsIG5vX2Fy Z3VtZW50LCBOVUxMLCAzfSwKKwkJeyJieXBhc3NybHMiLCBub19hcmd1bWVudCwgTlVMTCwgNH0s CisJCXsibm8tYnlwYXNzcmxzIiwgbm9fYXJndW1lbnQsIE5VTEwsIDV9LAogCQl7ImNvbm5lY3Rp b24tbGltaXQiLCByZXF1aXJlZF9hcmd1bWVudCwgTlVMTCwgJ2MnfSwKIAkJeyJwd3Byb21wdCIs IG5vX2FyZ3VtZW50LCBOVUxMLCAnUCd9LAogCQl7ImVuY3J5cHRlZCIsIG5vX2FyZ3VtZW50LCBO VUxMLCAnRSd9LApAQCAtNzYsNyArNzgsOCBAQCBtYWluKGludCBhcmdjLCBjaGFyICphcmd2W10p CiAJCQkJY3JlYXRlcm9sZSA9IFRSSV9ERUZBVUxULAogCQkJCWluaGVyaXQgPSBUUklfREVGQVVM VCwKIAkJCQlsb2dpbiA9IFRSSV9ERUZBVUxULAotCQkJCXJlcGxpY2F0aW9uID0gVFJJX0RFRkFV TFQ7CisJCQkJcmVwbGljYXRpb24gPSBUUklfREVGQVVMVCwKKwkJCQlieXBhc3NybHMgPSBUUklf REVGQVVMVDsKIAogCVBRRXhwQnVmZmVyRGF0YSBzcWw7CiAKQEAgLTE2NSw2ICsxNjgsMTIgQEAg bWFpbihpbnQgYXJnYywgY2hhciAqYXJndltdKQogCQkJY2FzZSAzOgogCQkJCWludGVyYWN0aXZl ID0gdHJ1ZTsKIAkJCQlicmVhazsKKwkJCWNhc2UgNDoKKwkJCQlieXBhc3NybHMgPSBUUklfWUVT OworCQkJCWJyZWFrOworCQkJY2FzZSA1OgorCQkJCWJ5cGFzc3JscyA9IFRSSV9OTzsKKwkJCQli cmVhazsKIAkJCWRlZmF1bHQ6CiAJCQkJLyogZ2V0b3B0X2xvbmcgYWxyZWFkeSBlbWl0dGVkIGEg Y29tcGxhaW50ICovCiAJCQkJcGdfbG9nX2Vycm9yX2hpbnQoIlRyeSBcIiVzIC0taGVscFwiIGZv ciBtb3JlIGluZm9ybWF0aW9uLiIsIHByb2duYW1lKTsKQEAgLTMwNCw2ICszMTMsMTAgQEAgbWFp bihpbnQgYXJnYywgY2hhciAqYXJndltdKQogCQlhcHBlbmRQUUV4cEJ1ZmZlclN0cigmc3FsLCAi IFJFUExJQ0FUSU9OIik7CiAJaWYgKHJlcGxpY2F0aW9uID09IFRSSV9OTykKIAkJYXBwZW5kUFFF eHBCdWZmZXJTdHIoJnNxbCwgIiBOT1JFUExJQ0FUSU9OIik7CisJaWYgKGJ5cGFzc3JscyA9PSBU UklfWUVTKQorCQlhcHBlbmRQUUV4cEJ1ZmZlclN0cigmc3FsLCAiIEJZUEFTU1JMUyIpOworCWlm IChieXBhc3NybHMgPT0gVFJJX05PKQorCQlhcHBlbmRQUUV4cEJ1ZmZlclN0cigmc3FsLCAiIE5P QllQQVNTUkxTIik7CiAJaWYgKGNvbm5fbGltaXQgPj0gLTEpCiAJCWFwcGVuZFBRRXhwQnVmZmVy KCZzcWwsICIgQ09OTkVDVElPTiBMSU1JVCAlZCIsIGNvbm5fbGltaXQpOwogCWlmIChyb2xlcy5o ZWFkICE9IE5VTEwpCkBAIC0zNjYsNiArMzc5LDggQEAgaGVscChjb25zdCBjaGFyICpwcm9nbmFt ZSkKIAkJCSAiICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRoYW4gdXNpbmcgZGVmYXVsdHNc biIpKTsKIAlwcmludGYoXygiICAtLXJlcGxpY2F0aW9uICAgICAgICAgICAgIHJvbGUgY2FuIGlu aXRpYXRlIHJlcGxpY2F0aW9uXG4iKSk7CiAJcHJpbnRmKF8oIiAgLS1uby1yZXBsaWNhdGlvbiAg ICAgICAgICByb2xlIGNhbm5vdCBpbml0aWF0ZSByZXBsaWNhdGlvblxuIikpOworCXByaW50Zihf KCIgIC0tYnlwYXNzcmxzICAgICAgICAgICAgICAgcm9sZSBjYW4gYnlwYXNzIHJvdy1sZXZlbCBz ZWN1cml0eSAoUkxTKSBwb2xpY3lcbiIpKTsKKwlwcmludGYoXygiICAtLW5vLWJ5cGFzc3JscyAg ICAgICAgICAgIHJvbGUgY2Fubm90IGJ5cGFzcyByb3ctbGV2ZWwgc2VjdXJpdHkgKFJMUykgcG9s aWN5XG4iKSk7CiAJcHJpbnRmKF8oIiAgLT8sIC0taGVscCAgICAgICAgICAgICAgICBzaG93IHRo aXMgaGVscCwgdGhlbiBleGl0XG4iKSk7CiAJcHJpbnRmKF8oIlxuQ29ubmVjdGlvbiBvcHRpb25z OlxuIikpOwogCXByaW50ZihfKCIgIC1oLCAtLWhvc3Q9SE9TVE5BTUUgICAgICAgZGF0YWJhc2Ug c2VydmVyIGhvc3Qgb3Igc29ja2V0IGRpcmVjdG9yeVxuIikpOwo= --=_0ec1189d168f87550ad0299a9f301384--