Re: Password authorization - Mailing list pgsql-admin

From Mladen Gogala
Subject Re: Password authorization
Date
Msg-id d4fd7ed1-5dd5-7a1b-0df1-5df80cc3f0cc@gmail.com
Whole thread Raw
In response to Re: Password authorization  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Password authorization  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
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.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

pgsql-admin by date:

Previous
From: Дмитрий Иванов
Date:
Subject: Re: Password authorization
Next
From: Laurenz Albe
Date:
Subject: Re: Password authorization