1) Create a new pluggable database called YOURINITIALS_Proj8. Verify that OLS is enabled in your pluggable database. If

[answerhappygod]

1) Create a new pluggable database calledYOURINITIALS_Proj8.Verify that OLS is enabled in your pluggable database. If it isn't,then enable it and re-verify.Within your pluggable database, run the following commands: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;
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 viewing to target the minds of diplomats through theirdreams');insert into GOVERNMENT_PROJECTS values (1436, 'Rainbow', 'Researchinto weather controlling technology');insert into GOVERNMENT_PROJECTS values (1577, 'Hoverboard','Anti-gravity research');insert into GOVERNMENT_PROJECTS values (1296, 'Mindwrecker','Attempts to induce paralysis in an enemy via mentalimpairment');insert into GOVERNMENT_PROJECTS values (1863, 'Bluebook', 'Speadingdisinformation about UFOs');insert into GOVERNMENT_PROJECTS values (1864, 'Saucer', 'Hidingfrom the general public that Aliens are real!');insert into GOVERNMENT_PROJECTS values (1895, 'Clamchowder','Hiding the fact that aliens killed JFK');insert into GOVERNMENT_PROJECTS values (1066, 'Eyeshine', 'A soundbased weapon that will induce temporary blindness');
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_Knowledge
NOTE: All users should be able to read data with their ownaccess AND all access levels below.Apply the policy to the GOVERNMENT_PROJECTS table
Give the following access levels to the following users:President = Top_Drawer_Secretarmy_general = Top_Secretciachief = Secretsoldier = Unclassifiedscott = Public_Knowledge
Set the following labels to the following projectsPROJECT_NO Label1066 Public_Knowledge1102 Secret1296 Confidential1436 Privileged1577 Unclassified1863 Top_Secret1864 Top_Drawer_Secret1895 Top_Drawer_Secret
Change the policy to enforce on read
Connect as each user, do a SELECT * ON GOVERNMENT_PROJECTS toshow what each user can accessYou must submit: A screen shot of you connecting to your pluggabledatabase as each user and then having that user run SELECT * onGOVERNMENT_PROJECTS. So, you should have five (5) screen shots. Nomore, no less.