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 1nAgIZ-0007dU-Ob for pgsql-admin@arkaria.postgresql.org; Thu, 20 Jan 2022 22:52:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nAgIY-0000dK-N8 for pgsql-admin@arkaria.postgresql.org; Thu, 20 Jan 2022 22:52:54 +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 1nAgIX-0000dB-Vo for pgsql-admin@lists.postgresql.org; Thu, 20 Jan 2022 22:52:54 +0000 Received: from donkey.elm.relay.mailchannels.net ([23.83.212.49]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAgIT-0002jG-6r for pgsql-admin@lists.postgresql.org; Thu, 20 Jan 2022 22:52:53 +0000 X-Sender-Id: hostpapa|x-authuser|list.pg.gavan@pendari.org Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id 813506C1152; Thu, 20 Jan 2022 22:52:45 +0000 (UTC) Received: from hp309.hostpapa.com (unknown [127.0.0.6]) (Authenticated sender: hostpapa) by relay.mailchannels.net (Postfix) with ESMTPA id B888D6C0AAE; Thu, 20 Jan 2022 22:52:44 +0000 (UTC) X-Sender-Id: hostpapa|x-authuser|list.pg.gavan@pendari.org Received: from hp309.hostpapa.com (hp309.hostpapa.com [69.90.160.170]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384) by 100.103.158.96 (trex/6.4.3); Thu, 20 Jan 2022 22:52:45 +0000 X-MC-Relay: Neutral X-MailChannels-SenderId: hostpapa|x-authuser|list.pg.gavan@pendari.org X-MailChannels-Auth-Id: hostpapa X-Zesty-Duck: 44b804f4503021ab_1642719165302_2172030984 X-MC-Loop-Signature: 1642719165302:1280911308 X-MC-Ingress-Time: 1642719165302 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=pendari.org ; s=default; h=Content-Transfer-Encoding:Content-Type:MIME-Version:References :In-Reply-To:Message-ID:Date:Subject:Cc:To:From:Sender:Reply-To:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=ceff2ICh7EjtIDbHWmSe+SEwZ02kFiKTgzGQu0NSpOs=; b=YaycAqV2g9qHEWA6zvoHFCj+Vb OY5ZYmiljjKaQlqLEdX1GCgXlQmXIWGNkVDWHAyvhXCCwT0hOy7cuDNQSdL374HLHWE7fOLGCD3xo 9ljBnOJ2xTjxIbsQ0U0d8YnvWox+4fBK4y5UlmI1PTibHGj2B6FOh+p/puCnYrjeXc4gOjIHnI+hv MzU/R8cLmBcveU0T9B9a0roR0iCnUTW1Gty4eP9kSIV8BZwaPl+qE5KsUziSS01rYHPVmXvf48I8J ua5o/TMYiKAZuDQlBHje6UXykwEm9FF4M9WCCDK+SdPke/lQ+ncieW2v1ia33cyEF+uwLJvABhst9 tp5kSbzw==; Received: from [103.152.126.17] (port=51595 helo=[192.168.20.22]) by hp309.hostpapa.com with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1nAgIM-004aI6-DD; Fri, 21 Jan 2022 09:52:43 +1100 From: Gavan Schneider To: pgsql-admin Cc: Laurenz Albe , Daulat Subject: Re: Password authorization Date: Fri, 21 Jan 2022 09:52:27 +1100 X-Mailer: MailMate (1.14r5860) Message-ID: <2D2D1BDD-A6F8-4EAE-B302-2C39DB5CE81B@pendari.org> In-Reply-To: References: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-AuthUser: list.pg.gavan@pendari.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 21 Jan 2022, at 3:24, Daulat wrote: > Yes, you are right, I am planning for password complexity rules and to,= force users to change their password. > While you are in the planning stages you may wish to review current best = practice, e.g., USA National Institute of Standards and Technology. For me the most interesting aspect of the revised standard is how forcing= password changes and complexity rules often leads to reduced security in= the real world. Refer: https://pages.nist.gov/800-63-3/sp800-63-3.html https://auth0.com/blog/dont-pass-on-the-new-nist-password-guidelines/ (fo= r a more human readable version :) Regards Gavan Schneider =E2=80=94=E2=80=94 Gavan Schneider, Sodwalls, NSW, Australia Explanations exist; they have existed for all time; there is always a wel= l-known solution to every human problem =E2=80=94 neat, plausible, and wr= ong. =E2=80=94 H. L. Mencken, 1920