Blakely, Jerel (Mission Systems) wrote:
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