Getting Error On VPD After Upgrading From 12.1 To 12.2
(Doc ID 2428633.1)
Last updated on AUGUST 10, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Creating a table with a virtual column like:
bsn_nr_pseudo as (SUBSTR("DM"."F_HASH_BSN"("BSN_NR"),1,32)))
and a policy that for some users they cannot see the bsn_nr column. This column is used for joining tables (with the same construction)
To still make it usable we have introduced the virtual column to join different tables on the bsn_nr_pseudo column. Everybody can see the bsn_nr_pseudo column.
This worked fine in 12.1 but now in 12.2 the following error is present:
FOUT in regel 2:
.ORA-28113: Fout in policypredicaat.
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