Postgres Pro
Downloads
Home   >   mailing lists

Thread: Password Change Mandatory during First Login

Password Change Mandatory during First Login

From
SASIKUMAR Devaraj
Date:
Hi All

Please advise whether it is possible to force the user to change password during first login.

Regards
Sasi

Re: Password Change Mandatory during First Login

From
Kashif Zeeshan
Date:
Hi SASIKUMAR

PG does not support such feature directly.

Thanks & Regards
Kashif Zeeshan

On Tue, Aug 27, 2024 at 2:37 PM SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
Hi All

Please advise whether it is possible to force the user to change password during first login.

Regards
Sasi

Re: Password Change Mandatory during First Login

From
Muhammad Waqas
Date:
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@yahoo.com> wrote:
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.

Re: Password Change Mandatory during First Login

From
SASIKUMAR Devaraj
Date:
We tried it. After validity ends, the user account expires and not prompting to change password 


Sent from Yahoo Mail for iPhone

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.

On Tue, 27 Aug 2024 at 14:37, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
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.

Re: Password Change Mandatory during First Login

From
Laurenz Albe
Date:
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@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.
> >
> > On Tue, 27 Aug 2024 at 14:37, SASIKUMAR Devaraj <sashikumard@yahoo.com> 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

Re: Password Change Mandatory during First Login

From
S Hoffman
Date:
Good morning Sasi,

You can write a Python script to achieve the goal. It requires connecting to the database externally but can significantly enhance your security if done correctly. I would advise you to find someone experienced with database programming and security to set this up.

Please let me know if you have any questions.

Thank you,
Sondra

Sent from my iPhone

On Aug 27, 2024, at 2:37 AM, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:


Hi All

Please advise whether it is possible to force the user to change password during first login.

Regards
Sasi