Re: Password Change Mandatory during First Login

On Thu, 2024-08-29 at 03:59 +0000, SASIKUMAR Devaraj wrote:
> We tried it. After validity ends, the user account expires and not prompting to change password 
>
> On Tuesday, August 27, 2024, 3:34 PM, Muhammad Waqas <waqas(dot)m(at)bitnine(dot)net> wrote:
> > yes you can by  CREATE ROLE foo LOGIN PASSWORD 'foo' VALID UNTIL '2021-11-22';
> >
> > but password authentication in pg_hba.conf should be enable.
> >
> > On Tue, 27 Aug 2024 at 14:37, SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com> wrote:
> > > Hi All
> > >
> > > Please advise whether it is possible to force the user to change password during first login.

Right; there is no way in PostgreSQL to prompt a password change.

Yours,
Laurenz Albe