Multiple T Codes to check User Authorization

[Former Member]

Dear All,

I had requirement to check the list of tcodes assigned to the users.

Here the input is multiple tcodes(i.e, more than 10 tcodes).

Please provide your inputs / suggestions in this regard.

Regards,

Venkatesh

[bhagya_affu]

Hi ,

1st find out the roles for these multiple t-codes using AGR_1251 table then

use AGR_USERS table to find users associated to these roles.

[Former Member]

Dear Afreem,

Thank you very much for the reply, is there anyway to fetch the details in a single instance.

Regards,

Venkatesh

[Former Member]

Hi Venkatesh,

You can use join the below mentioned tables using SQVI transaction and generate the report as per your requirement:

Table Name:

1) AGR_1251

2) AGR_USERS

You can refer the below mentioned document on how to prepare report using SQVI transaction:

Regards,

Hardik Patel

[Former Member]

Dear Hardik,

Thank you veryn much for the reply, is there anyway to fetch the details in a single instance.

Regards,

Venkatesh

[Former Member]

Hi venkatesh,

to fetch the details in a single instance goto SUIM>transactions>Executable for user. Execute & give the user name & execute again.

now export it to a spreadsheet say excel & then match it with your required tcodes.

hope this will help you.

Thanks

KS

[Former Member]

Dear Kashyap,

Here the input is tcodes not users.

Regards,

Venkatesh

[former_member226273]

Hello Venkatesh,

I agree with Kashyap. After exporting the report Transaction->Executable for user, you can filter the needed data from excel.

Kind regards,

Yashasvi