Answer the following questions related to SQL, ORACLE.

(1) For each of the following scenarios, suggest what steps the DataBase Administrator (DBA) the IT Director should perform:

(a) Tammy Smith, a loyal employee who has worked for JJJ Incorporated for ten years, announced her retirement and gave the " usual " two weeks' notice.

(b) Joseph Sands, as soon as he was suspected of employee theft, was immediately terminated. He ran the retail department for Big Box Mart.

(c) Mary Pappas, who currently works at the research and development facility as a chemist and formulates new products, has been recruited by another department to development the operations research program for the company. She has accepted the new position.

(2) What are the best practices to ensure security on a database using such an IDE as SQL Developer?

(3) Distinguish between a role, a profile and a privilege. Support your answer (please use APA for your citations).

(4) What is the danger to assigning / granting to PUBLIC ?

(5) Charles was given the order to grant specific privileges to Nick on Charles' table named food_club_members. Nick is a new - hire and will be working with Charles to maintain and manipulate important database files for the Eats - a - Lot Corporation.

Instead of using the following code for Nick

grant All on food_club_members to nick_01_user;

Charles used the code

grant All on food_club_members to public;

which he immediately executed. Some unscrupulous employee began to download the entire food_club_members to their flash drive.

What actions should the DBA and Charles' supervisor perform?