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 Waqas
Senior Technical Support Engineer - Tech Support Center (Karachi)
Mobile: +92-322-2844150
Email: waqas.m@xxxxxxxxxxx
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.
