Oracle Error ORA-28111: insufficient privilege to evaluate policy predicate

Oracle Error Message

ORA-28111: insufficient privilege to evaluate policy predicate

Reason for the Error

Predicate has a subquery which contains objects that the owner of policy function does not have privilege to access.

Solution

Grant appropriate privileges to the policy function owner.