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
|