public inbox for [email protected]
help / color / mirror / Atom feedPassword Change Mandatory during First Login
6+ messages / 5 participants
[nested] [flat]
* Password Change Mandatory during First Login
@ 2024-08-27 09:36 SASIKUMAR Devaraj <[email protected]>
2024-08-27 10:01 ` Re: Password Change Mandatory during First Login Kashif Zeeshan <[email protected]>
2024-08-27 10:04 ` Re: Password Change Mandatory during First Login Muhammad Waqas <[email protected]>
2024-08-29 13:26 ` Re: Password Change Mandatory during First Login S Hoffman <[email protected]>
0 siblings, 3 replies; 6+ messages in thread
From: SASIKUMAR Devaraj @ 2024-08-27 09:36 UTC (permalink / raw)
To: Pgsql-admin <[email protected]>
Hi All
Please advise whether it is possible to force the user to change password during first login.
RegardsSasi
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password Change Mandatory during First Login
2024-08-27 09:36 Password Change Mandatory during First Login SASIKUMAR Devaraj <[email protected]>
@ 2024-08-27 10:01 ` Kashif Zeeshan <[email protected]>
2 siblings, 0 replies; 6+ messages in thread
From: Kashif Zeeshan @ 2024-08-27 10:01 UTC (permalink / raw)
To: SASIKUMAR Devaraj <[email protected]>; +Cc: Pgsql-admin <[email protected]>
Hi SASIKUMAR
PG does not support such feature directly.
Thanks & Regards
Kashif Zeeshan
On Tue, Aug 27, 2024 at 2:37 PM SASIKUMAR Devaraj <[email protected]>
wrote:
> Hi All
>
> Please advise whether it is possible to force the user to change password
> during first login.
>
> Regards
> Sasi
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password Change Mandatory during First Login
2024-08-27 09:36 Password Change Mandatory during First Login SASIKUMAR Devaraj <[email protected]>
@ 2024-08-27 10:04 ` Muhammad Waqas <[email protected]>
2024-08-29 03:59 ` Re: Password Change Mandatory during First Login SASIKUMAR Devaraj <[email protected]>
2 siblings, 1 reply; 6+ messages in thread
From: Muhammad Waqas @ 2024-08-27 10:04 UTC (permalink / raw)
To: SASIKUMAR Devaraj <[email protected]>; +Cc: Pgsql-admin <[email protected]>
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 <[email protected]>
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
Email: *[email protected] <[email protected]>*
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password Change Mandatory during First Login
2024-08-27 09:36 Password Change Mandatory during First Login SASIKUMAR Devaraj <[email protected]>
2024-08-27 10:04 ` Re: Password Change Mandatory during First Login Muhammad Waqas <[email protected]>
@ 2024-08-29 03:59 ` SASIKUMAR Devaraj <[email protected]>
2024-08-29 10:56 ` Re: Password Change Mandatory during First Login Laurenz Albe <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: SASIKUMAR Devaraj @ 2024-08-29 03:59 UTC (permalink / raw)
To: Muhammad Waqas <[email protected]>; +Cc: Pgsql-admin <[email protected]>
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 <[email protected]> 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 <[email protected]> wrote:
Hi All
Please 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: [email protected] 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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password Change Mandatory during First Login
2024-08-27 09:36 Password Change Mandatory during First Login SASIKUMAR Devaraj <[email protected]>
2024-08-27 10:04 ` Re: Password Change Mandatory during First Login Muhammad Waqas <[email protected]>
2024-08-29 03:59 ` Re: Password Change Mandatory during First Login SASIKUMAR Devaraj <[email protected]>
@ 2024-08-29 10:56 ` Laurenz Albe <[email protected]>
0 siblings, 0 replies; 6+ messages in thread
From: Laurenz Albe @ 2024-08-29 10:56 UTC (permalink / raw)
To: SASIKUMAR Devaraj <[email protected]>; Muhammad Waqas <[email protected]>; +Cc: Pgsql-admin <[email protected]>
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 <[email protected]> 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 <[email protected]> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Password Change Mandatory during First Login
2024-08-27 09:36 Password Change Mandatory during First Login SASIKUMAR Devaraj <[email protected]>
@ 2024-08-29 13:26 ` S Hoffman <[email protected]>
2 siblings, 0 replies; 6+ messages in thread
From: S Hoffman @ 2024-08-29 13:26 UTC (permalink / raw)
To: SASIKUMAR Devaraj <[email protected]>; +Cc: Pgsql-admin <[email protected]>
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 <[email protected]> wrote:
>
>
> Hi All
>
> Please advise whether it is possible to force the user to change password during first login.
>
> Regards
> Sasi
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-08-29 13:26 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-27 09:36 Password Change Mandatory during First Login SASIKUMAR Devaraj <[email protected]>
2024-08-27 10:01 ` Kashif Zeeshan <[email protected]>
2024-08-27 10:04 ` Muhammad Waqas <[email protected]>
2024-08-29 03:59 ` SASIKUMAR Devaraj <[email protected]>
2024-08-29 10:56 ` Laurenz Albe <[email protected]>
2024-08-29 13:26 ` S Hoffman <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox