Virtual Private Database (VPD)

Searching Web, specially Oracle and Microsoft Websites, and via talking with any database administrator you may know, come with at least three situations where virtual private databases (VPD) can be utilized (3 situation at least).

Prepare a 3-4 pages of technical document in MS Word Format on usage, utilization, and implementation of Virtual Private Databases (VPD) for the cases of your choice.Explain each situation in details, and describe how it works?

Note : A Virtual Private Database (VPD) is a shared database schema containing data that belongs to many different users and that each user can view or update only data he or she owns.

• A VPD deals with data access
• VPD controls data access at the row or column level

SQL implements VPD using the VIEW object while Oracle10g provides specific functions for row-level security and fine-grained access.

Example of purposes of using virtual private databases:

• Security requirements necessitate data access be restricted at row or column level
• One database schema serves multiple unrelated groups or entities

A VPD deals with data access: VPD controls data access at the row or column level

Oracle10g: Specific functions – Row-level security, fine-grained access

This assignment is a research and Written Report.

Your written assignment must follow these formatting requirements:

Typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA/> format.

Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the

Cover Sheet and Reference page are not included in the required page length

Include charts or diagrams created in Excel, Visio, MS Project. The completed diagrams/charts must be imported into the Word document before the paper is submitted.

Grading for this assignment will be based on answer quality, logic/organization of the paper. Please save your document in Word Format.