A virtual private database or VPD masks
data in a larger
database 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 agency considered to provide wise and insightful counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. As such, it is a form of divination.
Description
The word '' ...
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 Insert may refer to:
*Insert (advertising)
*Insert (composites)
*Insert (effects processing)
*Insert (filmmaking)
*Insert key on a computer keyboard, used to switch between insert mode and overtype mode
*Insert (molecular biology)
*Insert (SQL)
*Fi ...
,
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