Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 92BC39FB702 for ; Sun, 28 Oct 2007 09:11:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 49941-02-2 for ; Sun, 28 Oct 2007 09:11:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id AFAE49FB4D2 for ; Sun, 28 Oct 2007 09:11:53 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1Im6zg-0005gb-95 for pgsql-admin@postgresql.org; Sun, 28 Oct 2007 05:11:52 -0700 Message-ID: <13452755.post@talk.nabble.com> Date: Sun, 28 Oct 2007 05:11:52 -0700 (PDT) From: rski To: pgsql-admin@postgresql.org Subject: Re: Postgresql New login - password expiration??? In-Reply-To: <13413089.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: robertski@o2.pl References: <13413089.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.332 tagged_above=0 required=5 tests=AWL=-0.557, BAYES_20=-0.74, DNS_FROM_OPENWHOIS=1.13, WHOIS_MYPRIVREG=1.499 X-Spam-Level: * X-Archive-Number: 200710/291 X-Sequence-Number: 27205 I checked, he won't be able to log in. I'm not sure if postgres has an option to force users to change passwords after first log in. I think you will need a function or script. smiley2211 wrote: > > Hello all, > > I've created a new Postgresql login and I set an expiration date on the > account 'VALID until xx-xx-xxx'...will this require the user to CHANGE his > password at expiration or will it DISABLE the user account??? > > Also, how do I set password expiration on new accounts??? ---I want them > to CHANGE their password upon first logging in... > > Thanks...Michelle. > -- View this message in context: http://www.nabble.com/Postgresql-New-login---password-expiration----tf4692732.html#a13452755 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.