How To Disable All Users Not In A Certain EnterpriseOne Role

June 24, 2013June 20, 2013

Read Time:12 Sec

Below is the SQL that I used to disable all users except those that are in the SYSADMIN role:

UPDATE SY910.F98OWSEC 
SET SCEUSER = '02' 
WHERE SCUSER NOT IN 
(SELECT RLTOROLE FROM SY910.F95921 WHERE RLFRROLE = 'SYSADMIN') 
AND SCUSER  '*POLICY'

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)

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

How To Test A SQL Server Connection

There is an easy way to test your SQL Server connection when running Windows without any special software. I found...

Stewart Schatz

December 14, 2022December 14, 2022

4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell

I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....

Stewart Schatz

April 9, 2022

Get The Size & Record Count Of All Tables In A SQL Server Database

Use the SQL query below to display the size and record count of all tables in an SQL Server database....

Stewart Schatz

December 13, 2021December 13, 2021

How To Get AS400/iSeries Job Queue Information Using SQL

I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...

Stewart Schatz

November 1, 2021October 29, 2021

The EnterpriseOne CNC Job Description

The JD Edwards ERP Specialist is responsible for maintaining the JD Edwards EnterpriseOne platform and auxiliary systems from a development, CNC, system administration, and functional consultant perspective to create and maintain business solutions.

Stewart Schatz

October 29, 2021October 28, 2021

VirtualBox Fails After Windows 11 Upgrade (NtCreateFile failed)

Quick Tip: WebLogic NodeManager Fails To Start As Windows Service

Quick Tip: Determine Active Directory Account Status From The Windows Commandline

Where Is Java Installed?

Quick Tip: IBM Navigator for i Default URL

Windows God Mode… What!?!

Fun with ChatGPT

How To Test A SQL Server Connection

4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell

How To Disable All Users Not In A Certain EnterpriseOne Role

Author

Stewart Schatz

Average Rating

Leave a Reply Cancel reply