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@xxxxxxxxxxx> 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@xxxxxxxxx> 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
