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.m@bitnine.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@yahoo.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