Question Details
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 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:
Answered
QUALITY
Approved
ANSWER RATING
This question was answered on: Jan 02, 2020
PRICE: $15
Solution~000.zip (25.37 KB)
This attachment is locked

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
About this Question
STATUSAnswered
QUALITYApproved
DATE ANSWEREDJan 02, 2020
EXPERTTutor
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).
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.
