Re: Password management in PostgreSQL

Hello Community,

I wanted to know if password can be managed by the respective users at the
time of their login, after their password has been expired?

Consider the following case:

*postgres=# create user pavan with login password 'password' valid until
'November 5 16:30:00 2018';*
CREATE ROLE
\q

/>psql -d postgres -U pavan
Password for user pavan:XXXXXXXX

postgres=> select current_timestamp;
now
-------------------------------
* 2018-11-05 15:31:11.394+05:30*

\q

*Now at : 2018-11-05 16:31:11.394+05:30*

/>psql -d postgres -U pavan
Password for user pavan: XXXXXXXX
*psql: FATAL: password authentication failed for user "pavan"*

Now due to that "VALID UNTIL" option password got expired at 16:30 Hrs.

Now how can I ask user "pavan" to change his password at the time of login
without administrator intervening into it??

*I have checked with Oracle team, it provides this facility in-built. I
hope postgres is not provided with this type of password management
mechanism.

If so, can we think of a alternative wherein the corresponding user can be
enable to change his/her password??*

Looking forward to hear your valuable suggestions. Thanks in advance.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html