Skip to Content

Search for users that have a specific set of roles

Hello,

We're currently planning to replace some roles with composite roles. Now I want to search for users that have the role: Z_THIS_ROLE and Z_ANOTHER_ROLE.

I tried TA suim, but had no success, because it only let you search for users which have one of the given permissions (multiple selection). Do somebody know a transaction which could help me?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 22, 2018 at 05:00 PM

    Hello,

    I would use SE16 on table AGR_USERS.

    In the selection you put in Z_THIS_ROLE and Z_ANOTHER_ROLE.

    Now you get all users who have the one, the other, or both.

    Sort by user, export to excel and remove all users who have only one entry.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2018 at 02:01 PM

    Hi

    Use the transaction code PFCG enter the role name .

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I need to check which users are assigned to all of these roles. I know which users having one my roles, but I have more than 70 roles, which are literally 4 different levels of authorizations. I want to replace these roles with composite roles. Another problem is that some authorization levels have the same roles assigned to them, that's why I need to search for the all of the roles the authorization level should have. I cannot search for only one role.

  • Nov 22, 2018 at 05:07 PM

    Hello,

    or double SE16. Search Users for one role, copy users to the clipboard.

    Second SE16 with your stored users and second role.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2018 at 09:15 AM

    Hi,

    in case of many role you need to check, I would use SE16 and select all needed roles. Export the result to Excel and do a pivot table over the data (e.g. user as row label, role as column label, count of client as Value) to get a first overview. For detail exploration you could filter on the role names. Maybe it is a good idea to remove all unwanted columns from your source data and afterwards remove double rows (e.g. user that have assigned the same role twice (with different start and end data).

    Regards

    Add comment
    10|10000 characters needed characters exceeded