E1: SEC: SQL 92 Left Outer Join Business View and Row Security (Doc ID 663779.1)

Last updated on AUGUST 10, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

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?

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