User id - Role mapping

[Former Member]

Hi gurus,

I wanted to make a report which shows for a particular user how many roles and tcodes are assigened to the person.

Can you tell me which table stores this information.

I know i can get it through su01 & pfcg & suim but i wanted to make detail report for every user in one report.

Regards,

Nisit & Priya

[Former Member]

Hi gurus,

I wanted to make a report which shows for a particular user how many roles and tcodes are assigened to the person.

Can you tell me which table stores this information.

I know i can get it through su01 & pfcg & suim but i wanted to make detail report for every user in one report.

Regards,

Nisit & Priya

[Former Member]

Hi priya,

use the BAPI 'BAPI_USER_GET_DETAIL' for getting all the roles assigned to the user. We get the roles fromn the table 'ACTIVITYGROUPS' of this BAPI.

For each composite role u can check the associated roles in table 'AGR_AGRS' and the transactions assigned to a role in the table 'AGR_TCODES'.

Hope this is helpfull in resolving ur issue.

[Former Member]

Hi Priya,

check this standard report RSUSR002,this may be useful.

Regards,

Sravanthi