Auditing Activity in SAP HANA Systems

SAP Note 1704499 – System Measurement for License Audit
SAP Note  2499866 – Auditing Activity in SAP HANA Systems

select * from SYS.AUDIT_LOG where STATEMENT_USER_NAME = ‘SYSTEM’;
SELECT * FROM SYS.ALL_AUDIT_LOG;
SELECT * FROM SYS.AUDIT_LOG;

Please note that if viewed on SYSTEMDB, users also need the DATABASE AUDIT ADMIN or DATABASE ADMIN system privilege:
SELECT * FROM EFFECTIVE_PRIVILEGE_GRANTEES WHERE OBJECT_TYPE = ‘SYSTEMPRIVILEGE’ AND PRIVILEGE = ‘DATABASE AUDIT ADMIN’;

In HANA tenant database users with the AUDIT ADMIN, AUDIT OPERATOR, or AUDIT READ system privilege can view information in this AUDIT_LOG system view. For all other database users, this view is empty.

 

Also see here: https://data-flair.training/blogs/sap-hana-auditing/

https://answers.sap.com/questions/11423797/audit-policy-for-users-start-with-xxx01.html

Leave a Comment

Your email address will not be published. Required fields are marked *

Click here to draw a picture to include in your comment.