Who Has Access To That In EnterpriseOne (E1)?

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!

Tags: cnc, e1, enterpriseone, EnterpriseOne - Security, EnterpriseOne - SQLs, iseries, oracle, peoplesoft, sql, ube

Related posts

Post a Comment