Who Has Access To That In EnterpriseOne (E1)?

November 9, 2007May 30, 2014

Read Time:49 Sec

There are many things that I find frustrating about the GUI tools for EnterpriseOne (E1), especially when doing Systems Administration functions.

Apparently, I’m not the only one. We give read-only access to most of the SysAdmin applications to our developers. You may have your own opinions about that, but it’s what we chose to do.

Anyway, our development manager gets a lot of CNC-type questions from our users and doesn’t like to always “bother” us with them. One of the questions she gets is “Who has access to the application or UBE?”. She got tired of wading through the multiple GUI applications required to get that information and came up with a very slick SQL query that returns the information quickly:

Note: iSeries DB2 syntax

SELECT ABALPH, FSOBNM, RLFRROLE, RLTOROLE 
FROM SY811/F00950, SY811/F95921, SY811/F0092, PRODDTA/F0101 
WHERE FSOBNM = 'PXXXX' AND 
 FSUSER = RLFRROLE AND
 RLTOROLE = ULUSER AND 
 ULAN8 = ABAN8

Thanks Deb!

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

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