From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>, Muhammad Waqas <waqas(dot)m(at)bitnine(dot)net> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Password Change Mandatory during First Login |
Date: | 2024-08-29 10:56:16 |
Message-ID: | af56aeffe576361f6128c16de3cec3c717c97407.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)m(at)bitnine(dot)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(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | somnath som | 2024-08-29 11:52:05 | User Privileges Issue |
Previous Message | Wells Oliver | 2024-08-29 04:21:12 | Re: pg_repack and table statistics |