Security

 View Only
  • 1.  Extracting roles assigned to local user

    Posted Oct 21, 2025 04:47 AM

    Hi,

    I'm runnng cppm 6.11.12 ( soon to be  6.12.5) whchh hosts an RBACS service. Locl cppm users are assigned  a default role of [other] and then additional roles  based upon what systems they are allowed access to e.g. read only switch access, admin switch access, airwave ro/admin ....etc. This is doen via a role mapping policy snd an appropriate  enforcement  policy based upon  role assigne to a user. 

    As this has expanded, keeping track of rtoles assigne dtop users via the gui is a but tiresome. Was wondering if.  it might be possible to  use some magic SQL query to. grab hold of. all the roles assigned to a given local user ( in insight ? ) so i can easily. email it to appropriate people

    A



    -------------------------------------------


  • 2.  RE: Extracting roles assigned to local user

    Posted Oct 21, 2025 10:24 AM

    Are you asking for an easy way to determine what access has been assigned to a user created in the Local User repository?



    ------------------------------
    Carson Hulcher, ACEX#110
    ------------------------------



  • 3.  RE: Extracting roles assigned to local user

    Posted Oct 21, 2025 11:11 AM
    Yup.

    Guess could take the local user and the appropriate rule mapping xml files and generate something that uses the username as a key to looking in the DOM model
    A




  • 4.  RE: Extracting roles assigned to local user

    Posted Oct 23, 2025 05:36 AM

    I still don't fully understand what you try to achieve, as you can export the users and check roles from there; but if you have a complex role mapping and need to know the outcome, that may be a bit more work.

    If you are ok with historical data, so want to know the roles assigned to a user actuall logging in, you may create an Insight report and enable the CSV output for details. An example that I created:

    Then there select also an appropriate time interval, in the next page enable the field Roles. The resulting report has a CSV file that has columns like these:

    From there you may need to do some de-duplication.



    ------------------------------
    Herman Robers
    ------------------------
    If you have urgent issues, always contact your HPE Aruba Networking partner, distributor, or Aruba TAC Support. Check https://www.arubanetworks.com/support-services/contact-support/ for how to contact HPE Aruba Networking TAC. Any opinions expressed here are solely my own and not necessarily that of Hewlett Packard Enterprise or HPE Aruba Networking.

    In case your problem is solved, please invest the time to post a follow-up with the information on how you solved it. Others can benefit from that.
    ------------------------------



  • 5.  RE: Extracting roles assigned to local user

    Posted Oct 23, 2025 06:01 AM
    Yup , got a report that does the for users logging on. They want a list of. All users irrespective of whether they log on and what they are assigned to .

    Can export the appropriate role mapping file and then do some XPath searches on it based upon the list of defined local users

    A




  • 6.  RE: Extracting roles assigned to local user

    Posted Oct 23, 2025 06:54 AM

    Based on your information we have to guess how your role mapping and enforcement policies looks like.

    But my guess is that you have something like this in the role mapping policy:

    User1 > switch admin
    User1 > firewall read
    User2 > switch read
    User2 > firewall admin
    User3 > switch operator

    In the enforcement policy you map the different roles to Network Device groups and send correct enforcement profiles.

    Is this a correct guess?

    If this is correct, I think the issue is that you have built something you normally handles in Active Directory or LDAP groups and not in ClearPass. As you have seen there are no reports on how the role mapping policy is built. If you are skilled with xml and text editing tools I suppose you could extract the role mapping policy as an xml file, create a script that strips and reformat the information to a more human readable format.

    Personally I don't have this type of skills.

    Otherwise, manual copy and paste to an Excel sheet may be a solution.



    ------------------------------
    Best Regards
    Jonas Hammarbäck
    MVP Guru, ACEX, ACDX #1600, ACCX #1335, ACX-Network Security
    Aranya AB
    If you find my answer useful, consider giving kudos and/or mark as solution
    ------------------------------



  • 7.  RE: Extracting roles assigned to local user

    Posted Oct 23, 2025 07:12 AM

    >Based on your information we have to guess how your role mapping and enforcement policies looks like.

    >But my guess is that you have something like this in the role mapping policy:

    >User1 > switch admin
    >User1 > firewall read
    >User2 > switch read
    >User2 > firewall admin
    >User3 > switch operator

    >In the enforcement policy you map the different roles to Network Device groups and send correct enforcement profiles.

    >Is this a correct guess?


    Yup thats correct 

    An excel cut'n pate would be one way, but as I've done a fair bit of XML , going to import xml into a nodes program and get it to  build a CSV file  containing
     Username and roles they have been assigned 

    A