public inbox for [email protected]help / color / mirror / Atom feed
Password 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]> 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 10:01 Kashif Zeeshan <[email protected]> parent: SASIKUMAR Devaraj <[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 10:04 Muhammad Waqas <[email protected]> parent: 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-29 03:59 SASIKUMAR Devaraj <[email protected]> parent: Muhammad Waqas <[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-29 10:56 Laurenz Albe <[email protected]> parent: SASIKUMAR Devaraj <[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-29 13:26 S Hoffman <[email protected]> parent: SASIKUMAR Devaraj <[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