change log for a specific user in HANA

[Former Member]

Hi SAP Gurus,

I am new to SAP HANA.

We have recently had an issue with one of the users in our HANA system where in certain Roles for the user got deleted due to which some of the jobs tied up with this user got failed. So we need to find out when these roles got removed and by whom. Please let me know if there is any table from which we can get this information.

Thanks,

Arjun

[Former Member]

Hi Arjun,

I believe AUDIT_LOG will help you find those kind of change history if it is enabled .

http://help.sap.com/saphelp_hanaplatform/helpdata/en/20/d3d56075191014af43d6487fcaa603/content.htm

Thanks

Siva

[Former Member]

Hi Siva,

Thanks for your help on this. I checked with our Team on this and they said the Audit_Log is not enabled in HANA.

Please let me know if there is any other way of getting the information without the audit log being enabled.

Thanks,

Arjun