3757018 - SYS.AUDIT_LOG view returns no rows although an audit policy is active and the trail type is set to TABLE

You have configured an audit policy in SAP HANA On Premise / HANA Cloud:

- The policy is enable (IS_AUDIT_POLICY_ACTIVE = TRUE)
- The policy is valid (IS_VALID = TRUE)
- The TRAIL TYPE is TABLE
- Auditable actions are being executed by users

However, when you query the audit log:

SELECT * FROM SYS.AUDIT_LOG
WHERE AUDIT_POLICY_NAME = '<YOUR_POLICY>'
ORDER BY TIMESTAMP DESC;

The result set is empty and no error is raised.

• SAP HANA Database 2.0 SPS04 and higher
• SAP HANA Cloud 
• SAP Datasphere

AUDIT_LOG, audit policy, AUDIT READ, AUDIT ADMIN, CS_AUDIT_LOG_, TRAIL TYPE, CSTABLE, global_auditing_state, EFFECTIVE_PRIVILEGES, M_INIFILE_CONTENTS , KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-CLS-HC , HANA Cloud Services HANA Cloud , DS-SM , Space Management , Problem