I have a timesheet database to track the work done each week by each employee for 70 plus employees. Each employee can access his own record but not other employees. The directors can check all the records from their own department. My plan is to set up 70 passwords and define the same previleges for each password, except directors'. I will then write a script so I can decide what records they can access based on the passwords they use. It is not hard but it does not feel right to me. What if we have 200 employees? I just define password 200 times and set privileges for each one of them? The script is going to be very long too? Am I missing something here? Thank you for your help

Use FMS 7's ability to link to LDAP or Active Directory to authenticate from a remote server.