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 1qb9tc-00BFmo-7F for pgsql-general@arkaria.postgresql.org; Wed, 30 Aug 2023 01:21:24 +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 1qb9tZ-00DLbG-Dt for pgsql-general@arkaria.postgresql.org; Wed, 30 Aug 2023 01:21:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qb9tY-00DLa9-Tg for pgsql-general@lists.postgresql.org; Wed, 30 Aug 2023 01:21:20 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qb9tT-001hPi-NX for pgsql-general@lists.postgresql.org; Wed, 30 Aug 2023 01:21:17 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-500c63c9625so1710970e87.2 for ; Tue, 29 Aug 2023 18:21:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1693358474; x=1693963274; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=SOgbhZ3CsbTFCIrrnsUxjO4yuXkCLeiNjc3FL99zw3g=; b=n6RQJIUC00cIa7IUqXdVR/THSp1kGJNnNNbz4VvW7vzxPBdOz+E37bhYQzo1dEN1g6 /QEgCshRqMX0+Mh6LW5/Oc0pgvz7IVV7d91eWjabG2WqNZBgIjHjEjnXQRG1lw+R0btX j4ysdMF0jx8rGacZCosEwpLnoAvrgtbX5vkP/o5ORgmz+2qVSMOoo/Nj+R+OXeRObdK3 dNlu6cVf4DiDuyOq8ZZXzyvQ5xQIsa18R29zTrrv388/sbjMUYPDTJrAL2DijgnYGhua bvemhkPp9TWBLcJBY3DRHsrUipkuBMxnyKM2U/v9eQuDQw5VmFIjEqnE8JIvIaOHjHFS MJ4Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693358474; x=1693963274; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=SOgbhZ3CsbTFCIrrnsUxjO4yuXkCLeiNjc3FL99zw3g=; b=Kz9ldJt7Xscis2UC8Dpie6O5occW7t7wqQ2L4dzRZXU446V3ulNVfD2EHBCySXzQtE 0fh/P6fw8v24umrvttqDtwFLiLXgEpiwG/IMlXFyMqPfiSH7VNF8wPRUTIzBeYUVKNOS DWp1dyUs5E21d7KQTbxD02crzR7E24detzXnVWxnHZmXDpXttECfnhZsdRN2Gy9iCpCu BJYCvptIn5HJdJf9+n+E/gIHLmVRaPoP+5Xysa1EgOJkXhHE2om7USoH1dMNClh6/Dg5 3AdT4fFyXeeLY1DwzHor4gf7gA3NKXPfnaHT9rfEzL0HlAR8PBjAO3tLwucN89VNgyiJ 59zQ== X-Gm-Message-State: AOJu0Yy024D9D/6J5x6NS3BMPRRFU7avXquKpxUDoxCt2czUB7HvssIe HVspBmEEnbAtWvYO196udhIaMgYFEOk8ZTmyuXY= X-Google-Smtp-Source: AGHT+IF0GDSnwkWkq/ZnT3gKQhQXQCi+BQ/rqGC76IL/xN56wcNZQYpKLne6d4WfN8azvNHYKtdhFQ== X-Received: by 2002:a19:8c07:0:b0:4f7:6453:f3f1 with SMTP id o7-20020a198c07000000b004f76453f3f1mr377718lfd.15.1693358473451; Tue, 29 Aug 2023 18:21:13 -0700 (PDT) Received: from localhost.localdomain (62-46-254-23.adsl.highway.telekom.at. [62.46.254.23]) by smtp.gmail.com with ESMTPSA id cf20-20020a170906b2d400b0098e78ff1a87sm6558103ejb.120.2023.08.29.18.21.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 29 Aug 2023 18:21:13 -0700 (PDT) Message-ID: <9ec51cd3b8d4d3402187cb89ca2afb3c99e64e48.camel@cybertec.at> Subject: Re: createuser unexpectedly creates superuser with createdb and createrole From: Laurenz Albe To: Erik Wienhold , "pgsql-general@lists.postgresql.org" Date: Wed, 30 Aug 2023 03:21:12 +0200 In-Reply-To: <60174207.340484.1693356258123@office.mailbox.org> References: <60174207.340484.1693356258123@office.mailbox.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gV2VkLCAyMDIzLTA4LTMwIGF0IDAyOjQ0ICswMjAwLCBFcmlrIFdpZW5ob2xkIHdyb3RlOgo+ IEkgcmVjZW50bHkgY3JlYXRlZCBhIHN1cGVydXNlciB3aXRoIGNyZWF0ZXVzZXIgb24gMTUuNCBh bmQgd2FzIHN1cnByaXNlZCB0aGF0Cj4gdGhlIHN1cGVydXNlciBhbHNvIGhhcyB0aGUgQ1JFQVRF REIgYW5kIENSRUFURVJPTEUgYXR0cmlidXRlIChhbHRob3VnaCByZWR1bmRhbnQKPiBmb3IgYSBz dXBlcnVzZXIpLsKgIFRoZSBkb2NzIFsxXSBldmVuIHNheSB0aGF0IC0tbm8tY3JlYXRlZGIgYW5k IC0tbm8tY3JlYXRlcm9sZQo+IGFyZSB0aGUgZGVmYXVsdHMuwqAgVGhvc2Ugb3B0aW9ucyBkb24n dCBldmVuIGhhdmUgYW4gZWZmZWN0IHdoZW4gdXNlZCBhbG9uZyB3aXRoCj4gLS1zdXBlcnVzZXIu wqAgSSBjaGVja2VkIENSRUFURSBVU0VSICh3aGljaCBJIG5vcm1hbGx5IHVzZSkgYW5kIGl0IGRv ZXMgbm90Cj4gYXV0b21hdGljYWxseSBzZXQgQ1JFQVRFREIgYW5kIENSRUFURVJPTEUuCj4gCj4g wqDCoMKgwqDCoMKgwqDCoCQgc3VkbyAtdSBwb3N0Z3JlcyBjcmVhdGV1c2VyIC0tc3VwZXJ1c2Vy IGFsaWNlCj4gwqDCoMKgwqDCoMKgwqDCoCQgc3VkbyAtdSBwb3N0Z3JlcyBjcmVhdGV1c2VyIC0t c3VwZXJ1c2VyIC0tbm8tY3JlYXRlZGIgLS1uby1jcmVhdGVyb2xlIGJvYgo+IMKgwqDCoMKgwqDC oMKgwqAkIHN1ZG8gLXUgcG9zdGdyZXMgcHNxbAo+IMKgwqDCoMKgwqDCoMKgwqBwb3N0Z3Jlcz0j IENSRUFURSBST0xFIGNhcm9sIFNVUEVSVVNFUjsKPiDCoMKgwqDCoMKgwqDCoMKgcG9zdGdyZXM9 IyBcZHUKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgTGlzdCBvZiByb2xlcwo+IMKgwqDC oMKgwqDCoMKgwqAgUm9sZSBuYW1lIHzCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqAgQXR0cmlidXRlc8KgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoCB8IE1lbWJlciBvZgo+IMKgwqDCoMKgwqDCoMKgwqAtLS0tLS0tLS0t LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0KPiDCoMKgwqDCoMKgwqDCoMKgIGFsaWNlwqDCoMKgwqAgfCBTdXBl cnVzZXIsIENyZWF0ZSByb2xlLCBDcmVhdGUgRELCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoCB8IHt9Cj4gwqDCoMKgwqDCoMKgwqDCoCBib2LCoMKgwqDC oMKgwqAgfCBTdXBlcnVzZXIsIENyZWF0ZSByb2xlLCBDcmVhdGUgRELCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCB8IHt9Cj4gwqDCoMKgwqDCoMKgwqDC oCBjYXJvbMKgwqDCoMKgIHwgU3VwZXJ1c2VywqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqAgfCB7fQo+IMKgwqDCoMKgwqDCoMKgwqAgcG9zdGdyZXPCoCB8IFN1cGVydXNl ciwgQ3JlYXRlIHJvbGUsIENyZWF0ZSBEQiwgUmVwbGljYXRpb24sIEJ5cGFzcyBSTFMgfCB7fQo+ IAo+IFRoZSBkb2NzIGZvciBjcmVhdGV1c2VyIGFsc28gc3RhdGUgdGhhdCAidGhlcmUgaXMgbm8g ZWZmZWN0aXZlIGRpZmZlcmVuY2UKPiBiZXR3ZWVuIGNyZWF0aW5nIHVzZXJzIHZpYSB0aGlzIHV0 aWxpdHkgYW5kIHZpYSBvdGhlciBtZXRob2RzIGZvciBhY2Nlc3NpbmcKPiB0aGUgc2VydmVyLiIK PiAKPiBUaGUgcHJvYmxlbSBJIHNlZSBoZXJlIGlzIHRoYXQgdGhlIGJlaGF2aW9yIGlzIHVuZXhw ZWN0ZWQuCgpJIGFtIHNvbWV3aGF0IHN1cnByaXNlZCB0b28sIGJ1dCBpdCBoYXMgYmVlbiBsaWtl IHRoYXQgc2luY2UgY29tbWl0IDhhZTBkNDc2YTkgaW4gMjAwNS4KClRoZSBjb2RlIGlzIHByZXR0 eSBjbGVhciBhYm91dCB0aGF0OgoKICAgIGlmIChzdXBlcnVzZXIgPT0gVFJJX1lFUykKICAgIHsK ICAgICAgICAvKiBOb3QgbXVjaCBwb2ludCBpbiB0cnlpbmcgdG8gcmVzdHJpY3QgYSBzdXBlcnVz ZXIgKi8KICAgICAgICBjcmVhdGVkYiA9IFRSSV9ZRVM7CiAgICAgICAgY3JlYXRlcm9sZSA9IFRS SV9ZRVM7CiAgICB9CgpJIHdvdWxkIHNheSB0aGF0IGNoYW5naW5nIHRoYXQgbG9uZyBzdGFuZGlu ZyBiZWhhdmlvciB3b3VsZCBjYXVzZSBtb3JlIGhhcm0gdGhhbiBiZW5lZml0LgpGaXJzdCwgYXMg dGhlIGNvZGUgc2F5cywgaXQgZG9lc24ndCBtYWtlIGEgbG90IG9mIGRpZmZlcmVuY2UuICBBbmQg d2hvIGtub3dzLCBwZXJoYXBzCnNvbWVvbmUgc29tZXdoZXJlIGNyZWF0ZXMgc3VwZXJ1c2Vycywg bGF0ZXIgY2hhbmdlcyB0aGVtIHRvIE5PU1VQRVJVU0VSIGFuZCBleHBlY3RzCkNSRUFURURCIGFu ZCBDUkVBVEVST0xFIHRvIGJlIHNldCBhZnRlciB0aGF0LgoKSWYgYW55dGhpbmcsIHdlIGNvdWxk IGFkZCBzb21ldGhpbmcgdG8gdGhlIGRvY3VtZW50YXRpb24uCgpZb3VycywKTGF1cmVueiBBbGJl Cg==