topic Re: Role Change LOG in Application Development and Automation Discussions

Role Change LOG

Former Member — Thu, 27 Jan 2011 21:40:21 GMT

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 — Fri, 28 Jan 2011 05:08:42 GMT

Hi Vasu,

Di you check DBTABLOG for the logs on table AGR_USERS.

Regards,

Srini.

Former Member — Wed, 06 Jul 2011 19:06:08 GMT

solved it myself

Former Member — Sat, 09 Jul 2011 08:19:25 GMT

Hi, you solved it ?

thx for sharing your solution.

Former Member — Sun, 10 Jul 2011 00:44:04 GMT

Hi,

please discard my question. I got the answer too.