Using Oracle Virtual Private Database to Control Data Access

The script content on this page is for navigation purposes only and does not alter the content in any way.

Oracle Virtual Private Database (VPD) enables you to filter users who access data.

Oracle Deep Data Security extends and modernizes Oracle Virtual Private Database and Real Application Security, moving from earlier procedural PL/SQL and API-driven controls to declarative policies in SQL. Oracle recommends using Deep Data Security to ensure identity propagation, database-enforced authorizations and audit compliance.

• About Oracle Virtual Private Database
  Oracle Virtual Private Database (VPD) provides important benefits for filtering user access to data.

• Components of an Oracle Virtual Private Database Policy
  A VPD policy uses a function to generate the dynamic WHERE clause, and a policy to attach the function to objects to protect.

• Configuration of Oracle Virtual Private Database Policies
  The DBMS_RLS PL/SQL package can configure Oracle Virtual Private Database (VPD) policies.

• Tutorials: Creating Oracle Virtual Private Database Policies
  These tutorials show how to create a simple and a database session-based Oracle Virtual Private policy, and how to create policy groups.

• How Oracle Virtual Private Database Works with Other Oracle Features
  You should be aware of the impact of using Oracle Virtual Private Database with other Oracle features.

• Oracle Virtual Private Database Data Dictionary Views
  Oracle Database provides data dictionary views that list information about Oracle Virtual Private Database policies.