My Oracle Support Banner

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 08, 2019

Applies to:

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


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
System - 900
Business Data - Test
<Server Name>

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

What is actually happening:

Why is this happening?




In this Document
