topic Re: Get user ids based on Authorisation object values in Application Development and Automation Discussions

Get user ids based on Authorisation object values

sankar_bhatta — Sat, 16 Mar 2019 12:08:49 GMT

HI,

In SUIM, we have an option for gettng user id based Authorisation objects and its values. Is there any FM and group of tables that I can join to fetch this data in a program. I have debugged SUIM but could not really find where the logic is.

Re: Get user ids based on Authorisation object values

Sandra_Rossi — Sat, 16 Mar 2019 13:36:43 GMT

To know which tables are accessed by SUIM, you may use a SQL trace, with the transaction code ST05.

Re: Get user ids based on Authorisation object values

sankar_bhatta — Sun, 17 Mar 2019 04:46:05 GMT

I have used ST05 and there are so many tables system queries. I am lost after an hour investigating those logs. Is there any FM / class ot set of tables that you can suggest to me.

Re: Get user ids based on Authorisation object values

Sandra_Rossi — Sun, 17 Mar 2019 08:11:28 GMT

Search the web then, for instance:

table authorization site:sap.com

Re: Get user ids based on Authorisation object values

s1252 — Sun, 17 Mar 2019 09:21:57 GMT

Did you try checking AGR_USER, AGR_1250 and any in this seri

Re: Get user ids based on Authorisation object values

DoanManhQuynh — Mon, 18 Mar 2019 00:49:46 GMT

you can get object and its profile from table USR12 or UST12.

user id and profile can get from table USR04.

so, join them and you can get the result you need.

i dont know what function module can do it, but for reference you can check function group: SU_USER. otherwise, you have to debug the SUIM to find out.

Re: Get user ids based on Authorisation object values

RaymondGiuseppi — Mon, 18 Mar 2019 09:49:21 GMT

Look at a report such as RSUSR002, even if you are not able (not enough time) to analyze it, it will generate an ALV and wrapping it with class CL_SALV_BS_RUNTIME_INFO, you can prevent actual display and get the data back in your program.

If you fill confident look for class CL_SUIM_AUTH_APPL or tables such as (example)

UST12 - UST10S - UST4
UST12 - UST10S - UST10C - UST4