[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] How do I force users to change their password?
From:       Chander Ganesan <chander () otg-nc ! com>
Date:       2008-05-23 16:43:42
Message-ID: 4836F43E.4050607 () otg-nc ! com
[Download RAW message or body]

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


[Attachment #3 (text/html)]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Blakely, Jerel (Mission Systems) wrote:
<blockquote
 cite="mid:1D29F363FE21EC4CA017E256383990B41DE98C@XMBTX122.northgrum.com"
 type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta name="Generator"
 content="MS Exchange Server version 6.5.7652.24">
  <title>How do I force users to change their password?</title>
<!-- Converted from text/rtf format -->
  <p><font face="Arial" size="2">The only setting I see is an account
expire, but I do not want to lock the people out of the accounts.</font>
  <br>
  <font face="Arial" size="2">I just want to force each user to set a
new password on minimum intervals.</font>
  </p>
  <p><font face="Arial" size="2">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?</font></p>
  <br>
</blockquote>
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.&nbsp; This can be accomplished with LDAP, Kerberos, or PAM.&nbsp;
However, I don't think that the native mechanism will allow you to do
what you are trying to accomplish.<br>
<pre class="moz-signature" cols="72">-- 
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
919-463-0999/877-258-8987
<a class="moz-txt-link-freetext" href="http://www.otg-nc.com">http://www.otg-nc.com</a></pre>
</body>
</html>


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic