Search for users that have a specific set of roles

[schuetz]

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?

[Sriram2009]

Hi

Use the transaction code PFCG enter the role name .

BR

SS

[schuetz]

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.

[JanSchlichting]

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

[JanSchlichting]

Hello,

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

Second SE16 with your stored users and second role.

Regards

[jörg_weichert]

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

[edgar2980]

Hello, I know it's been a long time since your question, but I have the same situation and I wonder if you were able to solve the problem?

From me it requires obtaining the users that have a specific set of roles. I see that the suim does an OR in the search for the roles and with an AND it seems to me that it would be the solution.