Chapter 12

image

Virtual Private Database

Using the secure views technique outlined in Chapter 10 can go a long way with quickly and affordably securing data in APEX applications and other applications. However, it does have some limitations that cannot be easily overcome.

Virtual Private Database (VPD) is a no-cost feature of the Oracle Database Enterprise Edition that dynamically adds WHERE clauses to any SQL statement used against a table or view. Managed by a simple PL/SQL function, VPD is a robust way to restrict which rows and columns a given user can view. In addition to restricting SELECT statements, VPD can be configured to also restrict ...

Get Expert Oracle Application Express Security now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.