Authorization value against tcodes of a user

[Former Member]

Dear All

We need to get a report from the system in following order

Identify which user in the system has what role assigned with list of tcodes and against every tcode there must be its relevant list of "assigned objects"and "values"

Ofcource SUIM can't handle this complexity but perhaps any specific table would be able to assist.

Looking forward to your reply

Thanks.

[Former Member]

Hello,

You will need the following tabels:-

User-Role Assignmet;- AGR_USERS

list of t-code:- AGR_TCODES

Assigned objects and values:- AGR_1251

You Can also get role description through AGR_TEXTS

Take all these data in excelsheet and then do Vlookup

[Former Member]

Hi

  You can get the information from the following tables.

AGR_DEFINE :  role defenition

AGR_PROF : link between profile and role

AGR_USERS : users that are assigned to the role

AGR_TEXTS : long text of roles

AGR_1251 : Authorisation objects and fields and values  that are in the roles profiles

agr_1252 : fields and values for  org. levels

AGR_TIME : role timestamps

AGR_FLAGS : role attributes

Thanks and Regards,

Vimal

[Former Member]

Dear Maria

I have achieved the level of getting user->roles via suim. And Authorization objects and fields and values  that are in the roles profiles via AGR_1251

I am looking forward to the mapping of tcodes between this layer. That which tcodes are having which authorization objects and values per role assigned to that user.

Thanks.

[Former Member]

Hi,

As far I know , you can get mapping of different tables as per your requirement with a help of an ABAPER.

You can find the detailed list of tables as below.

http://sap-basis-security.blogspot.in/2008/07/security-tables.html

http://www.erpgenie.com/sap-technical/security/sap-authorization-objects-tables

Thanks and Regards,

Vimal

[Former Member]

try this table USOBT_C

[marcosmata]

You cant get this information from SUIM.

The solution is an Abap Program. Looking for objects, roles and tcodes. Any abaper can help you!!!

Note: Are you sure you need this? its a LAAAARGE report.