(Answered) SDEV 350 Homework 3 - Oracle Virtual Private Database Overview: This homework provides an opportunity for the student to create a Virtual Private...

SDEV 350 Homework 3 - Oracle Virtual Private Database Overview: This homework provides an opportunity for the student to create a Virtual Private...

I need help secureing the SQL database. It is easy for me to follow an example but doing everything on my own takes up a lot of my time and I am also in intermeditae programming. Which actually is coming easier to me. Which tables should I use and how do I secure them?1

 

SDEV 350 Homework 3

 

–

 

Oracle Virtual Private Database

 

Overview:

 

This homework provides an opportunity for the student to create a Virtual Private Database in Oracle

 

Assignment: Total 100 points

 

Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a

 

Virtual Private Database that limits database access. Your design should be based on two of your

 

columns and two of your tables. (Hint:

 

where col1 = value1 AND col2 = value2).

 

Which columns and

 

tables you choose is up to you and will be based on your initial design. You may alter your tables if it

 

makes sense to do so.

 

Develop and conduct a test plan that clearly shows how access has been restricted by using the Virtual

 

Private Database.

 

In most cases you will need to create a separate policy and function for each of the two tables you

 

select. Use the tutorial as a reference and follow the steps for creating the policy function, creating the

 

virtual private database policy and testing the policy.

 

Deliverables:

 

1.

 

Create a word or PDF document that describes your process, steps and results. Be sure to

 

describe your schema and why you selected the tables and columns you did for your Private

 

database. Provide screen shots showing the successful running of all of your SQL statements and

 

testing your implementation. Be sure your testing is comprehensive and clearly demonstrates

 

how the virtual private database restricts access to specific records. The document should be

 

neat, well-organized, well-written and contain minimal grammar and spelling errors.

 

2.

 

A .sql script file containing all SQL statements you used for this effort. All SQL statements should

 

be in one file with appropriate connect statements to differentiate users who run the script. The

 

script file should contain comments describe each major set of SQL statements. The script

 

should run perfectly without error when executed from the Oracle SQL*PLUS environment.

 

Grading Rubric:

 

Attribute

 

Meets

 

Does not meet

 

Virtual Private

 

Database

 

50 points

 

Designs and implements a Virtual

 

Private Database that limits

 

database access. (20 points)

 

Design based on two of your

 

columns and two of your tables.

 

(20 points)

 

Creates a policy and function for

 

each of the tables used in Virtual

 

Private database. (10 points)

 

0 points

 

Does not design and implement a Virtual

 

Private Database that limits database

 

access.

 

Design is not based on two of your

 

columns and two of your tables.

 

Did not create a policy and function for

 

each of the tables used in Virtual Private

 

database.

 

---

Solution details:

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 02, 2020

EXPERT

Tutor

ANSWER RATING

YES, THIS IS LEGAL

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.