O'Reilly logo

Oracle APEX Best Practices by Learco Brizzi, Iloon Ellen-Wolff, Alex Nuijten

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Virtual Private Database

A very powerful feature of the Oracle database is Virtual Private Database (VPD). This feature is only available with the Enterprise edition. Virtual Private Database, also known as Row Level Security or Fine Grained Access Control, is a very popular choice of security when the standard object privileges and database roles are not sufficient. With VPD, you can specify which part (rows and/or columns) are accessible to the user. The policies that you specify can be as simple or complex as required.

VPD policies are defined against the database tables and are enforced whenever the table is accessed, regardless of the user interface that is being used. When the data is accessed through APEX or SQL*Plus, the same VPD policies ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required