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 = '<E1Role>'

Pretty simple… but, helpful!

Tags: e1, enterpriseone, EnterpriseOne - Security, EnterpriseOne - SQLs, security, sql

Related posts

• You’re Fired! …But You’re Still Here? – Cleaning EnterpriseOne (E1) Orphaned Records After Deleting a User Profile (0)
• Quick EnterpriseOne Version Security Solution (0)
• EnterpriseOne (E1) Version Promotion With Security (0)
• EnterpriseOne (E1) Security – Reset It All! (0)
• Who Has Access To That In EnterpriseOne (E1)? (0)