E1: SEC: SQL 92 Left Outer Join Business View and Row Security
(Doc ID 663779.1)
Last updated on JULY 29, 2022
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
I have an application that is based on a join business view. The application should display records that exist in the primary table even when there are no matching records in the secondary table. This works correctly until a user with row security uses the application. For a user with row security, only records that exist in both the primary and secondary tables are displayed in the application. Why are the results different in the application when row security is defined?
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