My Oracle Support Banner

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

Last updated on APRIL 30, 2024

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.170718 and later
Oracle Analytics Server - Version 2022 (6.4) to 2022 (6.4) [Release 12g]
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

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.