V$VPD_POLICY column PREDICATE is null. VPD policy is not enabled in User Session.
(Doc ID 2802340.1)
Last updated on SEPTEMBER 01, 2021
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
SELECT predicate FROM V$VPD_POLICY;
The predicate column is empty for the DB user for which the VPD policies are not getting applied. The DB user is able to view the rows which are protected by VPD, but as per the VPD policy definition the rows shouldn't be viewable by this DB user.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document