Add A JDE EnterpriseOne Environment To Every Role/Group

August 9, 2012

Read Time:11 Sec

You can use the below SQL to add an EnterpriseOne environment to every role or group in your installation:

INSERT INTO SY910/F0093 (LLUSER,LLLL,LLSEQ,LLMNI)
SELECT ULUSER, 'PD910','1.00','' FROM SY910/F0092

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com

Happy

Sad

Excited

Sleepy

Angry

Surprise

Average Rating

5 Star

4 Star

3 Star

2 Star

1 Star

(Add your review)

Quick Tip: IBM Navigator for i Default URL

This is a really quick one but I keep forgetting it: http://<SERVERNAME>:2004/ibm/console

Stewart Schatz

January 23, 2023October 23, 2023

Windows God Mode… What!?!

Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.

Stewart Schatz

January 5, 2023October 23, 2023