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 laterInformation 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 |