Message-ID: <af56aeffe576361f6128c16de3cec3c717c97407.camel@cybertec.at>
Subject: Re: Password Change Mandatory during First Login
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: SASIKUMAR Devaraj <sashikumard@yahoo.com>, Muhammad Waqas
	 <waqas.m@bitnine.net>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Thu, 29 Aug 2024 12:56:16 +0200
In-Reply-To: <1765910159.697824.1724903985777@mail.yahoo.com>
References: <519417424.215495.1724751414733.ref@mail.yahoo.com>
	 <519417424.215495.1724751414733@mail.yahoo.com>
	 <CAHYHq4XYw6dPAOXajwpFQm6k36dS1N+gf3q-H_cPp5q9igMqjw@mail.gmail.com>
	 <1765910159.697824.1724903985777@mail.yahoo.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/af56aeffe576361f6128c16de3cec3c717c97407.camel%40cybertec.at>
Precedence: bulk

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

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

Yours,
Laurenz Albe