08-20-2009 3:25 PM
Hi all,
I need to extract a list of users, with the following content.
USERNAME, ROLES ASSIGNED, ROLE DESCRIPTION
I am able to easily generate the list of users by searching via user group in SU01.
Does anyone know of a transaction or process I can use to get a list of the roles specifically assigned to each user without doing them INDIVIDUALLY via PFCG or SU01?
I can get the information via su01, pfcg or suim, however I have around 160 users in the list and doing this manually would be quite time consuming.
Any help would be greatly appreciated.
thanks!
08-20-2009 3:36 PM
This can be done by two stepps:
First
1. Run trx: SE16, enter table name: AGR_USERS.
2. Enter List of users. Uncheck all non required data. then Execute.
This will provide the list us roles vs users list.
Then get the list of role description. This can be easilly found out from SUIM.
Megring the two list you can get the required list.
Regards
Sandip.
08-20-2009 3:36 PM
This can be done by two stepps:
First
1. Run trx: SE16, enter table name: AGR_USERS.
2. Enter List of users. Uncheck all non required data. then Execute.
This will provide the list us roles vs users list.
Then get the list of role description. This can be easilly found out from SUIM.
Megring the two list you can get the required list.
Regards
Sandip.
08-20-2009 3:40 PM
You can also get the role description from table AGR_TEXTS, from memory you specify line 0 to return from each record set.
08-20-2009 4:00 PM