Обсуждение: Postgresql New login - password expiration???
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#a13413089 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
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.