public inbox for [email protected]  
help / color / mirror / Atom feed
From: Laurenz Albe <[email protected]>
To: SASIKUMAR Devaraj <[email protected]>
To: Muhammad Waqas <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Password Change Mandatory during First Login
Date: Thu, 29 Aug 2024 12:56:16 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<CAHYHq4XYw6dPAOXajwpFQm6k36dS1N+gf3q-H_cPp5q9igMqjw@mail.gmail.com>
	<[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





view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Password Change Mandatory during First Login
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox