Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdHgv-002pZ4-7v for pgsql-general@arkaria.postgresql.org; Mon, 04 Sep 2023 22:05:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qdHfu-00Ep1z-E8 for pgsql-general@arkaria.postgresql.org; Mon, 04 Sep 2023 22:04:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdHft-00Ep1g-Ut for pgsql-general@lists.postgresql.org; Mon, 04 Sep 2023 22:04:01 +0000 Received: from mout-u-107.mailbox.org ([2001:67c:2050:101:465::107]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdHfq-0034JL-66 for pgsql-general@lists.postgresql.org; Mon, 04 Sep 2023 22:04:01 +0000 Received: from smtp1.mailbox.org (smtp1.mailbox.org [10.196.197.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4RfjMZ0CdQz9sNb; Tue, 5 Sep 2023 00:03:54 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ewie.name; s=MBO0001; t=1693865034; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=DZc6Gc8Q/BYkMtc20hNwoulxHKBnSZ9BhrfDL1ZcklQ=; b=ddKf+OHwoHQHjHJ2zhjHCM1tNEEadoo52fOBmrier/nvBnI3HS5wbusyaFiDIVB+f3lzeb 3eqhIEVsfZzuKeNv1xfiVNCQs1gvBXR0O1xXCfarkVQIbbtmkGzH+QoBTYckNnWh7bJ+px Sbs3+YJl3pqaKYCXVk/e6mbfideyE7jGBtBbfQTMCnlkgkxM5Yk+JZ/qw9h2phCnPdKwND EdisPXNKChlX+RU8t9dQlJQ+E26Lri0+GUKAiY2ePrq8CRO2tVLR6x4qREWmw4XxoP1dkv Tuzc851au8p+UC5Zvh73EpOmCRNy66SSCcZL45m0S+pDZ/NWPOwYExySHEs2+Q== Date: Tue, 5 Sep 2023 00:03:53 +0200 (CEST) From: Erik Wienhold To: Tom Lane Cc: "pgsql-general@lists.postgresql.org" Message-ID: <498630446.200973.1693865033238@office.mailbox.org> In-Reply-To: <1046709.1693791744@sss.pgh.pa.us> References: <60174207.340484.1693356258123@office.mailbox.org> <9ec51cd3b8d4d3402187cb89ca2afb3c99e64e48.camel@cybertec.at> <1624623948.136031.1693791136215@office.mailbox.org> <1046709.1693791744@sss.pgh.pa.us> Subject: Re: createuser unexpectedly creates superuser with createdb and createrole MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_200972_1641658719.1693865033238" X-Priority: 3 Importance: Normal List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_200972_1641658719.1693865033238 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit On 04/09/2023 03:42 CEST Tom Lane wrote: > I think the last hunk of this is plenty sufficient, and the earlier > ones just add noise. Done. -- Erik ------=_Part_200972_1641658719.1693865033238 Content-Type: text/x-patch; charset=UTF-8; name=v2-0001-Document-implied-privileges-of-createuser-superus.patch Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=v2-0001-Document-implied-privileges-of-createuser-superus.patch X-Part-Id: 448b23d38b2f4537ace00f54dd8a465f RnJvbSA3NzI4ZmNhYjUzYzhlMDZjNzgxZjczNDc1MzJjYzg2MTk3OTlkOGZmIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBFcmlrIFdpZW5ob2xkIDxld2llQGV3aWUubmFtZT4KRGF0ZTog TW9uLCA0IFNlcCAyMDIzIDIzOjUwOjMzICswMjAwClN1YmplY3Q6IFtQQVRDSCB2Ml0gRG9jdW1l bnQgaW1wbGllZCBwcml2aWxlZ2VzIG9mIGNyZWF0ZXVzZXIgLS1zdXBlcnVzZXIKCkNvbW1pdCA4 YWUwZDQ3NmE5IGFkZGVkIG9wdGlvbiAtLXN1cGVydXNlciB0byBjcmVhdGV1c2VyLiAgSW4gY29u dHJhc3QKdG8gQ1JFQVRFIFJPTEUsIGNyZWF0ZXVzZXIgYWxzbyBncmFudHMgQ1JFQVRFREIgYW5k IENSRUFURVJPTEUgdG8gbmV3CnN1cGVydXNlcnMuICBUaGlzIGNvbW1pdCBkb2N1bWVudHMgdGhl IGltcGxpZWQgcHJpdmlsZWdlcy4KLS0tCiBkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZXVzZXIuc2dt bCB8IDMgKystCiAxIGZpbGUgY2hhbmdlZCwgMiBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0p CgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGV1c2VyLnNnbWwgYi9kb2Mvc3Jj L3NnbWwvcmVmL2NyZWF0ZXVzZXIuc2dtbAppbmRleCA1YzM0YzYyMzQyLi4wM2VmZWViZTE2IDEw MDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZXVzZXIuc2dtbAorKysgYi9kb2Mvc3Jj L3NnbWwvcmVmL2NyZWF0ZXVzZXIuc2dtbApAQCAtMjc1LDcgKzI3NSw4IEBAIFBvc3RncmVTUUwg ZG9jdW1lbnRhdGlvbgogICAgICAgPHRlcm0+PG9wdGlvbj4tLXN1cGVydXNlcjwvb3B0aW9uPjwv dGVybT4KICAgICAgIDxsaXN0aXRlbT4KICAgICAgICA8cGFyYT4KLSAgICAgICAgVGhlIG5ldyB1 c2VyIHdpbGwgYmUgYSBzdXBlcnVzZXIuCisgICAgICAgIFRoZSBuZXcgdXNlciB3aWxsIGJlIGEg c3VwZXJ1c2VyLiAgQWxzbyBpbXBsaWVzIDxvcHRpb24+LS1jcmVhdGVkYjwvb3B0aW9uPgorICAg ICAgICBhbmQgPG9wdGlvbj4tLWNyZWF0ZXJvbGU8L29wdGlvbj4uCiAgICAgICAgPC9wYXJhPgog ICAgICAgPC9saXN0aXRlbT4KICAgICAgPC92YXJsaXN0ZW50cnk+Ci0tIAoyLjQyLjAKCg== ------=_Part_200972_1641658719.1693865033238--