OBIEE 11g|12c: UserB Can See Data for UserA When Database Row Level Security Is Configured
(Doc ID 2294985.1)
Last updated on MAY 12, 2022
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.170718 and later
Oracle Analytics Server - Version 2022 (6.4) to 2022 (6.4) [Release 12g]
Information in this document applies to any platform.
You have configured row-level security Oracle virtual private database (VPD).
When UserA logs in to a Dashboard, the user results are correct, then userB logs into the same dashboard, this user gets the data for UserA, rather than the data specific to userB.
If after sometime, UserB logs into the same dashboard, he will get his own data correctly, but UserA will also get UserB's data.
You tested disabling the OBIEE server cache, but this did not resolve the issue and the results are the same.
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