mercredi 4 février 2015

Should login id and password be stored in separate table


I am working on my academic project. I have a table for employee records which have employee id, joining date, designation and other fields. I am trying to implement a scheme in which when record of employee is added first time in DB, a user name and temporary password will be generated so that New employee can use it to login in DB to see his details. I need to ask if it is good practice to save login id and password in employee record table? Or should I store them separately, but then I think I can not generate temporary password and id at time of inserting employee data in DB. Or is there any other way to implement this scheme?





Aucun commentaire:

Enregistrer un commentaire