Question:
Hi, all.
Not sure if this topic has been discussed before. Tried the search and nothing comes up.
I am trying to find out who has access to a table and through which activity group. I have located the authorization group for that table, but not sure how to dig up the activity group assigned the authorization group. The only way I found is using suim -> where-used list -> for authorization values. Then I enter Values -> S_TABU_DIS, Authorization group -> ZACS(that's the authorization group for that table). Run the report and select "profiles".
Is that the correct way? The result from the report does not look right to me although I cannot prove the report wrong. Please advise.
Thx,
SAP Dummy.
Answer:
you can find the roles in table agr_1251 and the users assigned to these roles in table agr_users
Answer:
Hi, auke_visser.
Thanks for the reply. But its seems like agr_users only has the mapping between the users and activity group. However, I need to find out the mapping between authorization group and users.
Any other idea?
Thx.
Answer:
From table AGR_1251.
Use the following selection criteria
Object= S_TABU_DIS
FIELD=DICBERCLS(if you need activity also leave this filed blank).
From above search you can see relation\ship between activity group and authorization group.You can join this with agr_users and find out which user have acess which authorization group.
Hope this helps.
MM
Answer:
Thank you very much for the extra explanation. You need to be patient to a dummy.