View Full Version : Can I create user level security with queries


robert693
06-18-2009, 05:44 AM
Hello,
I am creating a database with employee records. The database will be used by department managers. I want the database to show only those employee records that are in the department that pertains to the manager that has signed into the database. When a different manager signs in he or she will then see only the employee records from their department. I would like to know if I could do this by using queries somehow?

Thank you for any help!

DCrake
06-18-2009, 05:55 AM
Asuming that each employee has been assigned a department/manager in a field and managers login to the system. You can then apply filters to your queries to match up.

David

robert693
06-18-2009, 06:19 AM
Thank you!