Answer Happy

Project 81) Create a new pluggable database called YOURINITIALS_Proj8.2) Verify that OLS is enabled in your pluggable database. If itisn't, then enable it and re-verify.3) Within your pluggable database, run the followingcommands:create user president identified by president;create user army_general identified by armygeneral;create user ciachief identified by ciachief;create user soldier identified by soldier;create user scott identified by tiger ;grant create session to president, army_general, ciachief, soldier,scott;grant create table, unlimited tablespace to president;3) Connect to your pdb as President and run the following tablecreate:CREATE TABLE GOVERNMENT_PROJECTS (Project_NO NUMBER,Project_NameVARCHAR2(100), Project_Description VARCHAR2(500));insert into GOVERNMENT_PROJECTS values (1102, 'Deamscan', 'The useof remote viewingto target the minds of diplomats through their dreams');insert into GOVERNMENT_PROJECTS values (1436, 'Rainbow', 'Researchinto weathercontrolling technology');insert into GOVERNMENT_PROJECTS values (1577, 'Hoverboard','Anti-gravity research');insert into GOVERNMENT_PROJECTS values (1296, 'Mindwrecker','Attempts to induceparalysis in an enemy via mental impairment');insert into GOVERNMENT_PROJECTS values (1863, 'Bluebook', 'Speadingdisinformationabout UFOs');insert into GOVERNMENT_PROJECTS values (1864, 'Saucer', 'Hidingfrom the general publicthat Aliens are real!');insert into GOVERNMENT_PROJECTS values (1895, 'Clamchowder','Hiding the fact thataliens killed JFK');insert into GOVERNMENT_PROJECTS values (1066, 'Eyeshine', 'A soundbased weapon thatwill induce temporary blindness');4) Connect as a user with lbacsys access and create a policy calledols_govproj using a columnname lb_col and default option of no control.Then create the following level components for the policy:LEVEL NUMBER SHORT NAME LONG NAME10 TDS Top_Drawer_Secret9 TS Top_Secret8 S Secret
7 C Confidential6 P Privileged2 UC Unclassified1 PK Public_KnowledgeNOTE: All users should be able to read data with their own accessAND all access levels below.Apply the policy to the GOVERNMENT_PROJECTS table5) Give the following access levels to the following users:President = Top_Drawer_Secretarmy_general = Top_Secretciachief = Secretsoldier = Unclassifiedscott = Public_Knowledge6) Set the following labels to the following projectsPROJECT_NO Label1066 Public_Knowledge1102 Secret1296 Confidential1436 Privileged1577 Unclassified1863 Top_Secret1864 Top_Drawer_Secret1895 Top_Drawer_Secret7) Change the policy to enforce on read8) Connect as each user, do a SELECT * ON GOVERNMENT_PROJECTS toshow what eachuser can accessYou must submit: A screen shot of you connecting to your pluggabledatabase as each user andthen having that user run SELECT * on GOVERNMENT_PROJECTS. So, youshould have five(5) screen shots. No more, no less.