1. Case Project 4-1 Oracle Security (Page 160-162 of the textbook).
You are as a database administrator for a small reseller company to implement and administer the database component of their main application.
The data model of this application is presented in figure 4-20. The schema owner is called DBSEC.
a. Use the scripts provided to create schema.
b. Create three different profiles based on the criteria listed in table 4-7.
c. Create four different roles that have privileges according to the specification outlined in Table 4-8.
d. After creating these profiles and roles, create users according to the specifications in Table 4-9.
e. Verify your implementation by viewing the data dictionary.
The book is: Afyouni, Hassan. (2005). Database Security and Auditing: Protecting Data Integrity and Accessibility. Boston, MA: Course Technology (Cengage)