Re: Query on User account password change details

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Query on User account password change details
Date: 2021-05-07 14:41:05
Message-ID: 35005.1620398465@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> On Fri, May 7, 2021 at 08:55:15AM -0500, Ron wrote:
>> The problem is that Postgresql allows Really Short Passwords without
>> uttering a peep, and that's not defensible to an auditor.

> Have you considered passwordcheck?
> https://www.postgresql.org/docs/13/passwordcheck.html

BTW, this is a perfect example of why obsolete auditing rules actually
are a net negative to security. The only way passwordcheck can enforce
anything about the password's strength is if the server gets to see the
cleartext password. In these days of SCRAM, requiring that is in
itself bad practice: the cleartext password ought never leave the
client's machine.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vipin Madhusoodanan 2021-05-07 20:47:02 Re: Query on User account password change details
Previous Message Ron 2021-05-07 14:14:21 Re: Query on User account password change details