Problem 1. Assume you maintain a database containing confidential patient information and need to restrict UPDATE to only 5 individuals, allow only 15 others to view the database, and disallow any database access to all other users. Which access level would you assign to the 20 individuals in the first two groups and to the remaining users? For each of the three groups, describe every type of access granted to each one. This is using access levels including read/write, read-only, execute-only, and no access.
Problem 2. Given multi-network access, it's not unusual for users to have multiple user identifications and passwords. How would you manage these multi-password situations? Describe both the advantages and disadvantages of your solution.