Virtual Private Database metadata

Oracle captures the static and dynamic details of the VPD policies in dictionary views. You can query the following dictionary views to find the metadata about the Virtual Private Database security policies:

Dictionary view

Comments

[ALL | USER | DBA]_POLICIES

The view captures the security policy on objects accessible to a user, owned by a user, or within a database.

[ALL | USER | DBA]_POLICY_ATTRIBUTES

The view captures the application context namespaces, their attributes, and their association with the Virtual Private Database policy.

[ALL | USER | DBA]_POLICY_CONTEXTS

The view captures information about the driving contexts for the objects.

[ALL | USER | DBA]_POLICY_GROUPS

The view captures information ...

Get Advanced Oracle PL/SQL Developer's Guide - Second Edition 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.

Start your free trial