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 JANUARY 20, 2020

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?

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.