Consult changes in objects in a productive environment of the SAP HANA database

[jofc0315]

Good day,

I have a question about consulting changes in objects in a productive environment of the SAP HANA database:

1. In another forum they told me that it can be done through the SQL query:

"SELECT

OH.OBJECT_NAME,

OH.OBJECT_TYPE,

OH.SCHEMA_NAME,

OH.USER_NAME,

OH.OPERATION_TYPE,

OH. TIMESTAMP

FROM

SYS.M_OBJECT_HISTORY OH

WHERE

OH.IS_PRODUCED = 'TRUE'

ORDER BY

OH.TIMESTAMP DESC;"

2. Through transaction SE16 and table E070.

I would appreciate it if you could tell me which option is the most viable and if that option is described correctly.

Thank you. Greetings

[eason_chen]

Hi,

Alternatively, you may check HANA executed statement trace for DDL trace, ALTER or DROP. Following note can be referred.
2366291 - FAQ: SAP HANA Executed Statements Trace

Moreover, you may enable HANA audit trace for DDL SQLs.

Best Regards,
Eason Chen