Role Change LOG

[Former Member]

Hi,

I need information that on a particular date what all roles are added/changed/deleted for a given user.

I have checked table AGR_USERS but this only gives validity dates but not actions

FM BAPI_USER_GET_DETAIL also lists only the roles asssigned to user.

I have checked USH* tables

USH02

USH02_ARC_TMP

USH04

USH04_ARC_TMP

USH10

USH10_ARC_TMP

USH12

USH12_ARC_TMP

But they have change history of logon data, authorizations & Profiles but not Roles.

I have checked TCODE SUIM but I need to populate data programatically and show a report.

Please suggest me how can I get Change History of Roles - Table or FM

Thanks!

[Former Member]

Hi Vasu,

Di you check DBTABLOG for the logs on table AGR_USERS.

Regards,

Srini.

[Former Member]

solved it myself

[Former Member]

Hi, you solved it ?

thx for sharing your solution.

[Former Member]

Hi,

please discard my question. I got the answer too.