Homework answers / question archive / 12) Narrative of Employee Roles and an Access Control Matrix (ACM): Assume the department has 5 to 10 employees

12) Narrative of Employee Roles and an Access Control Matrix (ACM): Assume the department has 5 to 10 employees

MS Access

Share With

12) Narrative of Employee Roles and an Access Control Matrix (ACM): Assume the department has 5 to 10 employees. List the employee positions you think would be needed to run this process and describe their job responsibilities. Describe the various job functions that the employees would perform in your domain and develop an access control matrix. Strive for the best separation of duties that you can achieve in this small department. Then develop an ACM with permissions for access to all the database tables, reports and queries. Explain how and why you choose the various levels of permissions. See example below (2 to 4 pages).

ACM Example

Access Tables >                             Customer Table         Inventory Table      XYZ Table

Position:

Accounts receivable clerk                       1, 2                             1, 2

Manager                                                1, 2, 3, 4                  1, 2, 3, 4                       5                                           

Etc. 

Access permission controls will be based on the following list:

0 = No Access

1 = View Data

2 = View and Change Data

3 = View, Change and Delete Data

4 = View, Change and Add New Data

5 = View, Change, Delete and Add New Data