Create a Virtual Private Database in Oracle

Assignment Help Database Management System

Reference no: EM131853735

Homework - Oracle Virtual Private Database

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

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.

Formatting & Referencing: APA.

Reference no: EM131853735

Questions Cloud

Explain the term cost of sales in your own words : The background material for this module explains and shows examples of income statements. Pay attention to the layout and definitions of the income statement.

What are some ways of preventing corrupting : What are some ways of preventing corrupting and role should businesses play?

Invest directly in automobile production : What factors underlay the decision by Volkswagen to invest directly in automobile production in Russia?

Stock returns are good predictor of future returns : In finance, we generally assume that stock returns are normally distributed. Stock returns are a good predictor of future returns

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

Finding cost of overstocking : Moreover, in the South American option, you pay $5 to ship a unit of leftover to South America: this cost adds to the cost of overstocking (Co).

What are common attributes of hrm programs : What are common attributes of HRM programs, and what are effective employee outreach efforts that lead to engagement and high employee performance?

Overstatement or understatement errors in payroll liability : As the auditor, you are assigned to test whether there are any overstatement or understatement errors in the payroll liability for the Roger Corporation.

What role does corporate reputation play in organization : "Faced with clear evidence that it was losing market share because consumers increasingly preferred beverages without artificial flavoring and chemical.

User Account

All Pages