Who’s In That EnterpriseOne (E1) Role? 01.30.2008 · Posted in EnterpriseOne - Security, EnterpriseOne - SQLs 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, security, sql