Who’s In That EnterpriseOne (E1) Role?

Read Time:13 Sec

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.

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post JAS Server Name… GOTCHA!
Next post EnterpriseOne (E1) Record Locks