Wrong Results With ANSI Joins and VPD policies / Inline Views
(Doc ID 1073138.1)
Last updated on AUGUST 17, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.1.0 [Release 10.2 to 11.2]Information in this document applies to any platform.
Symptoms
Wrong results are produced when using an ANSI outer join on a table protected by a RLS policy. The problem can be reproduced also with an inline view that simulates the behaviour of RLS.
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 |
| References |