Question regarding SAP Users Data -> tcode authorization/super user/etc.

[Former Member]

Hello people,

I recently have to do something where I have to find the master data of the SAP user id's and its authorized transaction codes and to determine if what kind of users they are (i.e. super users).

I am assuming an SAP Table stores these data. My question is where will I be able to find the data I need stated above.

Also is there a table in SAP that connects the SAP USER ID, Activity Type, and the Tcodes the Act. Type has authorization.

Thanks and take care.

[Former Member]

Hi Chad,

Most of the user related information is stored in USR1/2/3 and so on tables. If you are aware of howo to do a sql trace you can use it by displaying any user master record. This will help you get the relevant information.

AGR_USERS - Assignment of roles to users

AGR_1016 - Name of the activity group profile

USR10 - User master authorization profiles

Hope this helps

Cheers

VJ

[Former Member]

Chad,

This info is available in quite a few standard reports. Take a Transaction SUIM and you will find lot of reports.

Regards,

Ravi

Note : Please mark the helpful answers