Project 8 1) Create a new pluggable database called YOURINITIALS_Proj8. Verify that OLS is enabled in your pluggable
Posted: Sun Jul 10, 2022 11:25 am
Project 81) Create a new pluggable database called YOURINITIALS_Proj8. Verify that OLS is enabled in your pluggabledatabase. If it isn't, then enable it and re-verify. Within your pluggable database, run the followingcommands: create user president identified by president; create user army_general identified byarmygeneral; 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 topresident;
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_PROJECTSto show 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.
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_PROJECTSto show 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.