Oracle Security
You are as a database administrator for a small reseller company to implement and adminster 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 creat 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.
Pages 160-161 in Database security and auditing, by Afyouni