Reference no: EM133673750

Database Security

The Company employs staff who have different job roles and permissions. Each area has a Manager who requires performance details. An Office Administrator looks after these performance details as well as the staff details and general information regarding the different types of staff. Helpdesk operators specialise in helping Callers and are the first line of contact. They take details of the Callers and the problem. When Callers have queries it is answered by the Helpdesk operator who tries to solve the problem however if it is complex then a Specialist will be allocated to investigate and fix the problem. IT Support staff are responsible for keeping an up to date inventory of all the software and hardware. Callers can view the progress of the problem they have reported using the problem number allocated to them by the helpdesk staff.

Task

Task: Backup and Security Strategy

As a database administrator, you are responsible for the security, availability and integrity of the data. But different kinds of threats and unavoidable failure can cause unauthorized access and corrupt the data.

Write a report, discussing the types of security threats and failures that might occur within the Oracle database environment and critically evaluating various security measures, backup and recovery strategies that could be implemented to ensure the data security, availability and integrity in the given company. Critically recommend relevant security and backup strategy for the given scenario. The selection should be fully justified and should explain how the proposed strategy would ensure data security and data recovery following a failure. Use relevant examples and references.

Special considerations should be given to the user and their access right and should consider various recovery strategies like differential files, shadow paging, mirroring, fallback areas etc.