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.