MIME-Version: 1.0
References: <519417424.215495.1724751414733.ref@mail.yahoo.com>
 <519417424.215495.1724751414733@mail.yahoo.com>
In-Reply-To: <519417424.215495.1724751414733@mail.yahoo.com>
From: Muhammad Waqas <waqas.m@bitnine.net>
Date: Tue, 27 Aug 2024 15:04:01 +0500
Message-ID: 
 <CAHYHq4XYw6dPAOXajwpFQm6k36dS1N+gf3q-H_cPp5q9igMqjw@mail.gmail.com>
Subject: Re: Password Change Mandatory during First Login
To: SASIKUMAR Devaraj <sashikumard@yahoo.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001613ae0620a75dd6"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHYHq4XYw6dPAOXajwpFQm6k36dS1N%2Bgf3q-H_cPp5q9igMqjw%40mail.gmail.com>
Precedence: bulk

--0000000000001613ae0620a75dd6
Content-Type: text/plain; charset="UTF-8"

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
Email:  *waqas.m@bitnine.net <waqas.m@bitnine.net>*
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.

--0000000000001613ae0620a75dd6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">yes you can by=C2=A0=C2=A0CREATE ROLE foo LOGIN PASSWORD &=
#39;foo&#39; VALID UNTIL &#39;2021-11-22&#39;;<div><br></div><div>but passw=
ord authentication in pg_hba.conf should be enable.</div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, 27 Aug 202=
4 at 14:37, SASIKUMAR Devaraj &lt;<a href=3D"mailto:sashikumard@yahoo.com">=
sashikumard@yahoo.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><div><div style=3D"font-family:&quot;Helvetica Neue&qu=
ot;,Helvetica,Arial,sans-serif;font-size:16px"><div dir=3D"ltr">Hi All</div=
><div dir=3D"ltr"><br></div><div dir=3D"ltr">Please advise whether it is po=
ssible to force the user to change password during first login.</div><div d=
ir=3D"ltr"><br></div><div dir=3D"ltr">Regards</div><div dir=3D"ltr">Sasi</d=
iv></div></div></blockquote></div><br clear=3D"all"><div><br></div><span cl=
ass=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmai=
l_signature"><div dir=3D"ltr"><div><img width=3D"96" height=3D"36" src=3D"h=
ttps://ci3.googleusercontent.com/mail-sig/AIorK4yAA065PNs0wTn63OKufwEq-K0ro=
rlKQ3zGggLzUsOI5cf2JvOBaG3rALen-RF0aigXFyuy850"><div dir=3D"ltr"><div dir=
=3D"ltr"><div><b><font size=3D"4">Muhammad Waqas</font></b></div><div><b>Se=
nior Technical Support Engineer - Tech Support Center (Karachi)</b></div><d=
iv><font style=3D"vertical-align:inherit">Mobile: +92-322-2844150</font></d=
iv><div><font style=3D"vertical-align:inherit">Email:=C2=A0=C2=A0<u><a href=
=3D"mailto:waqas.m@bitnine.net" target=3D"_blank">waqas.m@bitnine.net</a></=
u></font>=C2=A0</div><div><font style=3D"vertical-align:inherit">1st floor,=
 suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,=C2=A0</font></div><d=
iv><font style=3D"vertical-align:inherit">DHA Phase 5 Tauheed Commercial Ar=
ea,</font></div><div><font style=3D"vertical-align:inherit">Defense V Defen=
se Housing Authority, Karachi, Karachi City, Sindh,=C2=A0</font></div><div>=
<font style=3D"vertical-align:inherit">75500 Pakistan.</font></div></div></=
div></div><div><br style=3D"color:rgb(34,34,34)"></div></div></div>

--0000000000001613ae0620a75dd6--