Friday, May 23, 2008

Re: [ADMIN] How do I force users to change their password?

Blakely, Jerel (Mission Systems) wrote:
How do I force users to change their password?

The only setting I see is an account expire, but I do not want to lock the people out of the accounts.
I just want to force each user to set a new password on minimum intervals.

Does Postgres have a way to require users to change their passwords every 90 days for example, with out locking the account and forcing an admin to go in and update it?


I think the best you could do would be to tie authentication into some external system that requires a password change after a specified interval.  This can be accomplished with LDAP, Kerberos, or PAM.  However, I don't think that the native mechanism will allow you to do what you are trying to accomplish.
--  Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC  27560 919-463-0999/877-258-8987 http://www.otg-nc.com

No comments: