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.
Hi All
Please advise whether it is possible to force the user to change password during first login.
Regards
Sasi
-- 
Muhammad Waqas
Senior Technical Support Engineer - Tech Support Center (Karachi)
Mobile: +92-322-2844150
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,
75500 Pakistan.