Design and implement a Virtual Private Database

Assignment Help Database Management System

Reference no: EM131833227

Homework - Oracle Virtual Private Database

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

Assignment: 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.

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 to describe each major set of SQL statements. (Note: comments in an Oracle Script file may start with -- or be enclosed by /* */). The script should run perfectly without error when executed from the Oracle SQL*PLUS environment.

Reference no: EM131833227

Questions Cloud

Delivering health care in america-a systems approach : The organization and practices of modern hospitals reflect the promotion of specialization and subspecialization by academic medical centers.

Analyze the impact of big business on the economy : Analyze the impact of big business on the economy and politics and the responses of Americans to these changes.

Determining that did the given theory fail most of the time : When talking about the economy, people often make a distinction between policies that work "only in theory" compared to those that work "in practice."

Research indonesias dominant art forms : Research Indonesia's dominant art forms and unique holidays, dress, and foods. Incorporate Indonesia's martial art of Silat.

Design and implement a Virtual Private Database : SDEV 350 Homework - Oracle Virtual Private Database. Design and implement a Virtual Private Database that limits database access

Which of the given policies are credible : A monetary policy is said to be credible if the central bank will have an incentive to do tomorrow what it says today that it will do tomorrow.

Reflect on how policies affect your direct service work : Reflect on how policies affect your direct service work with clients in your fieldwork placement or employment.

Review problem on financial bubble : When a financial bubble collapses, is that more like a fall in aggregate demand or a fall in the potential growth rate?

Discuss the different type of shock : Central banks and voters alike usually want higher real growth and lower inflation. What kind of shock makes that happen?

User Account

All Pages