请输入您要查询的百科知识:

 

词条 Virtual private database
释义

  1. External links

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, 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 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

  • [https://web.archive.org/web/20070126071542/http://www.stanford.edu/dept/itss/docs/oracle/10g/network.101/b10773/apdvpoli.htm Using Virtual Private Database to Implement Application Security Policies]
  • http://www.devshed.com/c/a/oracle/row-level-security-with-virtual-private-database/
  • http://www.techrepublic.com/article/create-secure-virtual-private-databases-in-oracle/5034559/
  • http://www.oracle-base.com/articles/8i/VirtualPrivateDatabases.php
{{database-stub}}

2 : Data security|Types of databases

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/11/12 16:28:56