A database of Huwang Chun Solutions LLC, which sells body building materials can be arranged as follows.
Scenario:
A database of Huwang Chun Solutions LLC, which sells body building materials can be arranged as follows. There are a number of salespersons, sales department clerks, Shipping department clerks, warehouse supervisors, customers etc. in the company. Each salesperson is considered as a link between the customer and the company. The company sells number of products. Orders can be placed for one or more products at a time by the customers. When the order is complete, it can be shipped and then invoiced. An order can be distributed in more than one shipment (for e.g., if it is very huge) and similarly a shipment may contain more than one order (for e.g., if the orders are small). For the security purposes, users of the Huwang Chun database are grouped according to the functions they perform and security levels they are entitled to. For example, the sales department clerk’s duty is to enter/update the customer information, shipping department’s clerks create/update shipping data, warehouse supervisors handle products. Additionally, each group can view different information in different directions using various customized reports and temporary queries.
Task 1
As a DBA , identify and discuss any six database access control and authentication steps that are required to ensure database security of Huwang Chun Solutions L.L.C. To get an idea about the database access control and authentication steps you can refer to the webpage (https://searchsecurity.techtarget.com/magazineContent/Basic-Database-Security-Step-by-Step).
Note: Provide the screenshots.
Task 2
With appropriate citation and referencing, discuss the need of triggers for database auditing. Justify the answer by writing an appropriate PL/SQL block of code of a sample trigger and to monitor and record the different operations done by the users of Huwang Chun Solutions L.L.C. (as a part of auditing process).
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
