CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

iSeries User used to execute Queries

edited Aug 2, 2024 9:20PM in CNC, DB and Operating System - JDE1 (MOSC) 3 commentsAnswered

We are trying to lock down a database that is now archive. I always thought that the System User that is setup with the JDE User is the user that is used for determining data authorities. However, we found out that even though the system user is used for some system queries, the user that queries and updates PRODDTA data is ONEWORLD.

In the case below, we setup JDE user TESTRO and assigned it system user JDERO and setup that user on the iSeries. We turned on SQL monitoring and were surprised to see that ONEWORLD performs the queries, not the system user. This does make some sense because JDENET_K call object kernels are started with the ONEWORLD user and the QSQSRVR jobs that run the queries adopt the user from the kernel job.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center