My Oracle Support Banner

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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms


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.

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.