Audit trail to track old and new values on table, HANA DB level

[NitinUnnikrishnanNair]

Hi,

Is there any standard way of provisioning to track old and new values that performed on table directly from HANA DB level?

Thanks & Regards

Nitin

SAP HANA Cloud, SAP HANA database 

[Sandra_Rossi]

One possibility: CREATE TRIGGER to insert changes into a custom table. https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20d5a65575191014946db96...

[NitinUnnikrishnanNair]

Thanks Sandra,
Our auditors are demanding for the audit trail for all the HANA DB Tables including standard DB tables.
Any solution for this.

[umasaral]

Hi 

Please check the below To track old and new values in HANA DB for audit trails, you can use:

1. Change Data Capture (CDC): Implement CDC to track changes on tables. HANA provides a built-in mechanism for this.

2. Audit Logging: Enable audit logging in HANA to capture DML operations (INSERT, UPDATE, DELETE) on tables.

3. Triggers: Create database triggers to log changes in custom audit tables whenever data is modified.

4. Temporal Tables: Use temporal tables to automatically track historical data changes, if applicable.

These methods will help you maintain an audit trail for standard DB tables.

[Sandra_Rossi]

Out of curiosity, no offense intended by me, is it an answer made by Generative AI?

[craigcmehil]

Please remember our Rules of Engagement indicate that if GenAI is used it needs to be declared with a user label or in the text that it was "GenAI Assisted Content"

[Sandra_Rossi]

Thanks for the information! Link https://pages.community.sap.com/resources/rules-of-engagement > Article 3: Content Publication: "If you want to publish content that was helped/created by GenAI, you must add the user tag GenAI Assisted Content. For content where it's not possible to add a user tag (e.g., answers), you must include this statement: "GenAI was used to help generate this content.""