E1: SEC: How to Setup Different System User IDS to Manage User Access to Tables in Database Based on Datasources

(Doc ID 1394856.1)

Last updated on NOVEMBER 14, 2017

Applies to:

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

Symptoms

You use system user IDs to manage user access to databases.  For a userID (for example: USERX) you want to set different system users to connect to the database, depending on the datasource where the table that you need resides.

According to JD Edwards EnterpriseOne Tools 8.9.x Security Administration Guide section Understanding How to Create and Revise User Security it states:

Each time a user accesses a table through a JD Edwards EnterpriseOne application, the software searches for a security record for that user and the specific data source where the table resides. If the software does not find a specific record, then it uses the default data source, which is the security record that you created with the DEFAULT data source field.

To accomplish this, you put records in P98OWSEC (User security) for this userID, as shown in this table:

User ID / Profile
Data Source
System User
USERX
DEFAULT
SYSUSER
USERX
System - 900
JDE
USERX
Business Data - Test
JDE
USERX
<Server Name>
JDE


What should happen (according to the example given in the table above):

What is actually happening:

Why is this happening?

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