How to find SQL query for audit policy

[sbmrafikul2]

Hi All,

I have created a audit policy from HANA studio interface for all activity done by "SYSTEM" user . Its showing enable. But want to know the SQL query which is made because of that. Any idea from where I can find that.

I have already gone through this below link where it is mentioned how the audit policy is created & how the SQL query looks like. But i want see those from studio itself

CREATE AUDIT POLICY - SAP HANA SQL and System Views Reference - SAP Library

Any hint.

Regards,

Jituda

[lbreddemann · Accepted solution]

Easy as pie!

To review the SQL commands send by SAP HANA studio, you can use the JDBC trace. It can easily be enabled in the connection settings.

When active the connection entry in the navigator will be highlighted to indicate that the trace is active.

Make sure to close and reopen the Audit editor so that the connection it uses will be traced too.

- Lars