OBIEE 11g|12c: UserB Can See Data for UserA When Database Row Level Security Is Configured
Last updated on AUGUST 08, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 126.96.36.199.170718 and later
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms