Security and PrecautionsFor the medium-sized business schema used in Assignments 4 and 5, write the...

Question

Security and PrecautionsFor the medium-sized business schema used in Assignments 4 and 5, write the SQL statements for the following:Create roles forthe Managers, HR Specialists, and Other Users.Grant privileges to the roles as follows:All users have read access to all the tables except Employment.Managers have read access to all the tables (including Employment), plus the ability to apply inserts, updates, and deletes to all tablesexceptDivision, Department, Work_Group, Pay_Grade, Employment, and Employee_Work_Group_AssignmentHR Specialists have read access to all tables (including Employment), plus the ability inserts, updates, and deletes to the Division, Department, Work_Group, Pay_Grade, Employment, and Employee_Work_Group_AssignmentHint: To simplify your task, assume you can grant roles to other rolesList the security precautions you would recommend for each of the following database applications:Company personnel databaseHospital medical records databaseBank checking account databaseConsumer credit databaseAutomobile insurance claims databaseMedical insurance claims databasePersonal music library and playlist databasehw4 hw5 questions and answers are attached

Salony · Accepted Answer

1)
CREATE ROLE manager;
CREATE ROLE HR_Specialist;
2)
GRANT SELECT ON
party||Division||Party_role_type||Party_role_assign||contact_usage_type||contact_mechnaism||postal_address||email||item||purchase_order||Department||purchase_oder_item||Telephone||pay_grade||Wrokgroup||Employee_Work_group_Assignment to Manager
GRANT SELECT ON
party||Division||Party_role_type||Party_role_assign||contact_usage_type||contact_mechnaism||postal_address||email||item||purchase_order||Department||purchase_oder_item||Telephone||pay_grade||Wrokgroup||Employee_Work_group_Assignment to HR_Specialist
GRANT SELECT ON
party||Division||Party_role_type||Party_role_assign||contact_usage_type||contact_mechnaism||postal_address||email||item||purchase_order||Department||purchase_oder_item||Telephone||pay_grade||Wrokgroup||Employee_Work_group_Assignment to Other
REVOKE SELECT ON EMPLoyment to Other
3)
Grant select on party||Division||Employment||Party_role_type||Party_role_assign||contact_usage_type||contact_mechnaism||postal_address||email||item||purchase_order||Department||purchase_oder_item||Telephone||pay_grade||Wrokgroup||Employee_Work_group_Assignment to Manager;
Revoke insert,update,delete on
Division||Employment ||pay_grade||Wrokgroup||Employee_Work_group_Assignment to Manager;
Grant insert,update,

Security and Precautions For the medium-sized business schema used in Assignments 4 and 5, write the SQL statements for the following: Create roles forthe Managers, HR Specialists, and Other Users....

Security and Precautions

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment