Possibly add "expires" column to password table

[jmoore]

Currently we have no way to measure when a password should be changed. It might make sense to add an "expires" date column to the password table.

[jmoore]

Passing off to Ola who already has an implementation.

[atarkowska]

New column to PASSWORD table as created - date format with default value CURRENT_DATE To IAdmin: java.util.Date (or String) getUserPasswordCreatedDate(Long id); To Omero.properties: expire.time = 90 (days) To JbossLoginModule?: when protected String getUsersPassword() throws LoginException? makes a statement: select p.hash as PASSWD, p.dn as DN, p.created as CREATED from experimenter e, password p where e.omename=? and e.id = p.experimenter_id and checks password in DB (LDAP plugin will not contain this option or If Ldap has password expire date inside we can support it as well) gets rs.getDate(3).

If CREATED+expire.time < TodayDate? true else false

To WEBADMIN: On the users list we can icon for each of account where password expired. The same information on user details page