Automation with Power

Power Business Continuity and Automation

Learn about using IBM Power automation tools to automate repetitive tasks and quickly identify and resolve production issues. Start a discussion thread - share your experiences by writing a blog - and stay up to date by browsing the content library. 


#Power
#TechXchangeConferenceLab
 View Only
  • 1.  BRM User Roles

    Posted Fri January 24, 2025 02:40 PM

    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.



    ------------------------------
    Richard Weber
    ------------------------------

    #BRMSfori


  • 2.  RE: BRM User Roles

    Posted Fri January 24, 2025 03:06 PM

    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. 



    ------------------------------
    Rich Malloy
    ------------------------------