dba and sql programs with literature review

/in /by

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).

Note: Provide the screenshots.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.