When I further analyzed the system I could establish 10 distinct possible roles
ID: 3761359 • Letter: W
Question
When I further analyzed the system I could establish 10 distinct possible roles in the system. You may find more. If you do, feel free to add them. The ones I could establish were the following.
Benefits Manager who controls the Employee Table
Benefits Clerk who adds the dependents.
Payroll Manager who controls the Position Table.
Payroll Clerk who controls assignments and salary information.
Training Manager who creates courses.
Training Clerk who registers students.
Teachers who add grades.
Nursing Supervisor who controls the Diagnosis table.
Nurse who adds Medical Records.
Nursing Secretary who retrieves information for generating reports.
Please take this information and generate a security chart showing what privilege each user would have in regard to each table.
Explanation / Answer
Benefits Manager - All permission on Employee Table. Since the benefits manager can control all the fields of the employee table the manager should have all the read/write permissions on the benefits table.
Benefits Clerk - Clerk should have insert and update privilege on the table since he has to add records in the dependents table. we should not give alter, delete,drop privileges.
Payroll Manager - Payroll manager should have all the permissions on the position table. All the fields can be changed by payroll manager and therefore should have all the permissions.
Payroll clerk - Should have all privileges on assignment table and employee table.
Training Manager - Should have only insert privileges on course table as the job is to just add new courses.
Training Clerk - Should have only insert/update privilegeson course table.
Teachers - Should have Insert,Update privileges on courses table.
Nursing Supervisor - Should have all permission on Diagnosis and Medical records table as nursing supervisor is reponsible for all the work related to these two tables.
Nurse - Should have insert privileges on the Medical records table as only adding new records is allowed.
Nursing Secretarty - Should have only select privileges on all the tables to fetch any information.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.