topic Re: User id - Role mapping in Application Development and Automation Discussions

User id - Role mapping

Former Member — Fri, 23 May 2008 07:57:07 GMT

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 — Fri, 23 May 2008 10:35:40 GMT

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 — Mon, 26 May 2008 07:28:21 GMT

Hi Priya,

check this standard report RSUSR002,this may be useful.

Regards,

Sravanthi