topic Re: Multiple T Codes to check User Authorization in Application Development and Automation Discussions

Multiple T Codes to check User Authorization

Former Member — Wed, 01 Apr 2015 06:18:44 GMT

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

Re: Multiple T Codes to check User Authorization

bhagyabloosm1 — Wed, 01 Apr 2015 08:12:01 GMT

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.

Re: Multiple T Codes to check User Authorization

Former Member — Wed, 01 Apr 2015 10:25:19 GMT

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

Re: Multiple T Codes to check User Authorization

Former Member — Wed, 01 Apr 2015 10:31:48 GMT

Dear Hardik,

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

Regards,

Venkatesh

Re: Multiple T Codes to check User Authorization

Former Member — Wed, 01 Apr 2015 10:33:04 GMT

Dear Afreem,

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

Regards,

Venkatesh

Re: Multiple T Codes to check User Authorization

Former Member — Wed, 01 Apr 2015 11:04:20 GMT

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

Re: Multiple T Codes to check User Authorization

Former Member — Wed, 01 Apr 2015 11:24:42 GMT

Dear Kashyap,

Here the input is tcodes not users.

Regards,

Venkatesh

Re: Multiple T Codes to check User Authorization

former_member226273 — Thu, 09 Apr 2015 09:22:08 GMT

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