My Oracle Support Banner

Upgrade To 12.2.0.1 VPD Returns Inconsistant Results. (Doc ID 2509465.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.0.1 version, Database Security

ACTUAL BEHAVIOR
---------------
Upgrade  to 12.2.0.1, VPD now returns inconsistent results.

After upgrading to  12.2, inconsistent results are displaying when querying tables with VPD enabled on them.

For example,

1. I can run a query which returns 11 rows, when I wrap the same query into an "insert into <TEM_TABLE> select ..." it now returns 53 rows.

2.  one time it doesn't return any data, and second time same query  reruns a few data.

3. There were no issues in 12.1

4. VPD policies were created like so:

BEGIN
DBMS_RLS.ADD_POLICY(
 object_schema => <SCHEMA_NAME>',
 object_name => '<TABLE_NAME>',
 policy_name => '<POLICY_NAME>',
 function_schema => '<FUNCTION_SCHEMA>',
 policy_function => 'FUNCTION_NAME',
 statement_types => 'select, insert, update, delete',
 enable => true,
 update_check => true,
 policy_type => dbms_rls.STATIC);
END;
/

5. 12.2 database was also patched to latest 2018Q4 RU (patch 28689128)

 

EXPECTED BEHAVIOR
-----------------------

Queries should not behave differently with same amount of data with same policy.

Changes

 Database Was upgraded to 12.2

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
Changes
Cause
Solution
References


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