SDEV 350 Homework
Virtual Private Database
provides an opportunity for the student to create a
Virtual Private Database in Oracle
Total 100 points
Using the Schema you developed in Homework 1 for your e
design and implement a
Virtual Private Da
tabase that limits
. Your design should be
based on two of your
columns and two of your tables.
col1 = value1 AND col2 = value2).
Which columns and
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.
In most cases you will need to create a separate policy
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.
Create a w
ord or PDF document that
es your process steps and results. Be sure
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
testing your implementation
. Be sure your testi
ng is comprehensive and clearly demonstrate
how the virtual private database
restricts access to specific records.
The document should be
and contain minimal grammar and spelling errors.
A .sql script file containing all
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