IBM BRMS for i

I am looking for a way to view the BRM users on our systems for audit purposes.  The SETUSRBRM command adds users and changes their roles, but there is no WRK or DSPUSRBRM command to see who is already out there and what they can do from what I can find.

Hi Richard - I believe you have to use an SQL Service that looks at the underlying Functional Usage for BRMS.

For example - this will show which users have access to certain Functional Areas - i.e - BRMS

SELECT * FROM QSYS2.FUNCTION_USAGE ORDER BY FUNCTION_ID, USER_NAME;

From the Helptext associated with SETUSRBRM





Note - the SQL above will show ALL Functions - you can tweak the SQL as you needed.