OBIEE 11g|12c: UserB Can See Data for UserA When Database Row Level Security Is Configured (Doc ID 2294985.1)

Last updated on AUGUST 08, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.170718 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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