Question: I need only database table filled out Deliverable 4: DB Maintenance (60 points) Project Question 2: Describe processing rights that you think would be appropriate
I need only database table filled out
Deliverable 4: DB Maintenance (60 points)
Project Question 2: Describe processing rights that you think would be appropriate for this situation. Use the following template table as a guide and see Figure 6-17, pp.383 in textbook for an example. What problems might this security system have?
| DATABASE RIGHTS GRANTED | |||
| Table | Management | Administrative | System Administrator |
| OWNER |
|
|
|
| EMPLOYEE |
|
|
|
| SERVICE |
|
|
|
| PROPERTY |
|
|
|
Garden Glory has also developed an initial procedure for backup and recovery and asks you for evaluation. The company backs up the database from the server to a second computer on its network each night. Once a month, it copies the database to a CD and stores it at a manager's house. It keeps paper records of all services provided for an entire year. If it ever loses its database, it plans to restore it from a backup and reprocess all service requests.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
