Employee SSN Name Salary DN ZZ 001 ADAMS 20000 C100 U 002 BAKER 45000 C200 C 003 CHUCK 70000 C300 S 004 DONNER 135000 C400 TS 1) Create an OLS policy…

004 DONNER 135000 C400 TS

1)   Create an OLS policy that will accomplish the following:

a.    The policy is named OLS, with a column_name of ZZ with READ_CONTROL;

b.    The Security Levels allowed in the policy are as required to implement the hierarchical levels in the above table (i.e., Levels of U, C, S, and TS)

c.    The Data Labels are as required to implement the policy for the above table (Data Labels of U, C, S, and TS); e.g., the data label 100 for unclassified. That the Users (all of the users; i.e., ADAMS, BAKER, CHUCK, DONNER) are created as indicated in the above table and given the DAC rights necessary to access the above table (e.g., Create User ADAMS identified by A; Grant Create Session to ADAMS, Grant Select on Employee to ADAMS);

d.    That the Users have the MAC rights as indicated in the above table (the Level for ADAMS is U, the Level of BAKER is C, the Level for CHUCK is S, the Level for DONNER is TS

e.    That the OLS policy created is applied to the Above table (i.e., the OLS policy OLS is applied to the EMPLOYEE table. (NOTE: You can do steps a-e above before or after you create the Employee table. But you have to have the Employee table before you do f. I recommend that you create the table but DON’T insert the records in the table until the policy is applied to the table. When you create table DO NOT create the attribute ZZ. Create that table with the attributes as follows: SSN, Name, Salary, DN. The reason for this is that you cannot insert the records in the table with the labels until after you apply the label policy to the table. If you do create the records in the table before you apply the label policy none of the rows will have labels. When you apply the policy to the table another attribute will be added to the table, the ZZ attribute! Now you can insert the records (ANOTHER HINT; WHEN YOU INSERT THE ATTRIBUTE REMEMBER THAT THE LEVEL IS INSERTED BY ITS NUMBER, e.g, when you create the Unclassified level, U, you gave it a data tag of 100 — CREATE_LABEL(‘OLS’, 100, ‘U’); you insert it with the value 100; INSERT INTO EMPLOYEE VALUES (5, ‘ELF’, 40000, ‘C500’, 100);

2)   After all parts of 1 are completed; insert the 4 rows indicated above into the above table AND connect in turn as ADAMS, BAKER, CHUCK, AND DONNER DO A SELECT ON THE EMPLOYEE TABLE. (REMBER IF YOU CREATE THE EMPLOYEE TABLE AS db668a09 and are referencing the table as ADAMS you would Select * from db668a09.Employee;  When you do this you should get one record for ADAMS, 2 records for BAKER, 3 for CHUCK and 4 for DONNER. Each User sees the records at his level and of all the levels below.

Example

1)    SQL> connect adams/a

2)    Connected.

3)   SQL> select * from michael.employee;

4)    

5)          SSN NAME      SALARY DN          ZZ

6)   ———- —— ———- —- ———-

7)            1 ADAMS      20000 C100       100

8)    

9)   SQL> connect baker/b

10) Connected.

11) SQL> select * from michael.employee;

12)  

13)        SSN NAME      SALARY DN          ZZ

14) ———- —— ———- —- ———-

15)          1 ADAMS      20000 C100       100

16)          2 BAKER      45000 C200       200







Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10