Re: Password authorization - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Password authorization
Date
Msg-id 5e4ed7296493684b40a5fa7fb009edf92f5e9ade.camel@cybertec.at
Whole thread Raw
In response to Re: Password authorization  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-admin
On Fri, 2022-01-21 at 09:10 -0500, Mladen Gogala wrote:
> On 1/20/22 09:25, Laurenz Albe wrote:
>  
> > It is not quite clear what you mean, but I assume you want password complexity rules,
> > and you want to force users to change their password after a while.
> > 
> > You cannot do any of that with passwords in the database; the best you can
> > do is set an expiration time for the user's ability to log in.

> Actually, you can. There is the standard "passwordcheck" module described in the documentation:
> https://www.postgresql.org/docs/current/passwordcheck.html
> You would have to do some C programming, but it's very possible.

That is no solution, because it cannot check hashed passwords
(except with cracklib).  I wrote it.

Laurenz Albe





pgsql-admin by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Password authorization
Next
From: Stephen Frost
Date:
Subject: Re: Password authorization