Virtual Private Database (VPD) policies on INSERT and UPDATE statements are created with update check as FALSE
(Doc ID 2801971.1)
Last updated on SEPTEMBER 26, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
When attempting to create a Virtual Private Database (VPD) policy including INSERT and/or UPDATE statements, and setting the update check as FALSE in the DBMS_RLS.ADD_POLICY procedure, no error is obtained, the policy is successfully created and then queried in the DBA_POLICIES view:
However and according to this documentation, this action should not be possible, as when specifying INSERT and UPDATE statements for a policy to be created, the UPDATE_CHECK parameter must be set to TRUE, else, error ORA-28104 will be raised. What happened here?
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