Chapter 4. Virtual Private Database
In this chapter, we will cover the following tasks:
- Creating different policy functions
- Creating Oracle Virtual Private Database row-level policies
- Creating column-level policies
- Creating a driving context
- Creating policy groups
- Setting context as a driving context
- Adding a policy to a group
- Exempting users from VPD policies
Introduction
Oracle Virtual Private Database (VPD) is a security feature, introduced in Oracle Database 8i. It is available only in Enterprise Edition of Oracle Database. Discretionary access control (DAC) grants/restricts access to data at an object level (for example, table level). This means that a user can access either the entire data in a table or no data. VPD enables you more granular control ...
Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
