A virtual private database or VPD masks

data Data ( , ) are a collection of discrete or continuous values that convey information, describing the quantity, quality, fact, statistics, other basic units of meaning, or simply sequences of symbols that may be further interpreted for ...

in a larger

database In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...

so that only a subset of the data appears to exist, without actually segregating data into different tables, schemas or databases. A typical application is constraining sites,

departments Department may refer to: * Departmentalization, division of a larger organization into parts with specific responsibility Government and military * Department (administrative division), a geographical and administrative division within a country, ...

, individuals, etc. to operate only on their own records and at the same time allowing more privileged users and operations (e.g. reports, data warehousing, etc.) to access on the whole table. The term is typical of the

Oracle An oracle is a person or thing considered to provide insight, wise counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. If done through occultic means, it is a form of divination. Descript ...

DBMS, where the implementation is very general: tables can be associated to SQL functions, which return a predicate as a SQL expression. Whenever a query is executed, the relevant predicates for the involved tables are transparently collected and used to filter rows. SELECT, INSERT, UPDATE and DELETE can have different rules.

External links

Using Virtual Private Database to Implement Application Security Policies
* http://www.oracle-base.com/articles/8i/VirtualPrivateDatabases.php Data security Types of databases {{database-stub