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 AllPlease advise whether it is possible to force the user to change password during first login.RegardsSasi--Muhammad WaqasSenior Technical Support Engineer - Tech Support Center (Karachi)Mobile: +92-322-2844150Email: waqas.m@xxxxxxxxxxx1st 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.