Who’s In That EnterpriseOne (E1) Role?
One of the biggest things that the E1 security screens lack is the ability to see what users are in a particular group.
So, here is the SQL that you can use:
select * from sy811/f95921 where RLFRROLE = 'ROLENAME'
Pretty simple… but, helpful!
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.
More Stories
Quick Tip: Hold All JDE Job Queues
The following SQL statement will put all JDE Job Queues on hold: UPDATE SY920.F986130 SET QCQUSTS='02' This statement is very...
How To Disable Client Package Deployment
If you have a development client that has been neglected and JDE wants you to install 15 update packages but...
Quick Tip: Limit The Number Of Rows Returned From A SQL Query
This is pretty basic, but I had to look up the syntax to use for SQL on IBM DB2 so...
Quick Tip: Where Is An Application On The Menu?
The following SQL will give you a good idea if an application or UBE is on the menu and where...
Quick Tip: Decline All Update Packages Using SQL
A quick way to decline all packages that have been marked for deployment on a development client is use SQL:...
Quick Tip: Change A Scheduled Job’s Time Zone Using SQL
If you work with multiple time zones, especially if one uses Daylight Saving Time and the other does not, it...
Average Rating