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. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
