Chapter 5. Implementing VPD with Fine Grained Access Control

Data security has always been a questionable criterion for a solution which promises data repository. "How much is my data secure or vulnerable?" We make a lot of effort on the concepts of data storage, fetch optimization, and its integrity to ensure and evolve a concrete database philosophy. But the last question hovers every time the database design and security paradigms are planned. The Oracle database offers multiple solutions in variety of areas to enforce best security strategies on the data. Some of the focused areas have been securing user accounts, their authentication, their roles and privileges, data encryption, data audit, and data vaulting.

In this chapter, we will discuss one of the data security features which builds up a protocol or mechanism to impose latent dynamic querying criteria on the data selection. The security feature comes up with the name Fine Grained Access Control which is also known as Virtual Private...