CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Setup Read Only JDE ID / Datasource Override not working for user profile

Hello,

I am trying to setup a Read Only JDE environment where it reads some data from a shared data source that is used by 2 environments and some data from a data source that has archive tables (OCM Override). I have created a Database user with Select only access and added that DB user as a system user in JDE. In P98LPSEC, I have created a Data Source override and used the Read DB id. However, when I login to JDE, it uses the default system user "JDE" which has both Read and Write access.

Any Idea why this setup does not work ? Can you suggest any other options.. Those suggesting that I can use Action security with all buttons disabled do not consider batch programs that can update data. In a worse case scenario, I was thinking of using a dedicated data source instead of shared with JDE system user having Read only access to the tables.

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