Here is how you can truncate AUDIT_LOG table:
If the audit trail target is a database table, you can avoid the audit table growing indefinitely by deleting audit entries created up until a certain time and date. You can do this using the Security editor of the SAP HANA studio.
NOTE: It is recommended to archive the audit entries before proceeding with these steps. Also, you must have the system privilege AUDIT OPERATOR to perform this activity.
use the SQL command ALTER SYSTEM CLEAR AUDIT LOG ALL to completely clear the table contents.
Incase if you wish to remove the audit logs for a specific period, use the below:
ALTER SYSTEM CLEAR AUDIT LOG UNTIL ‘2022-01-15 23:59:59’;
If you wish to delete the audit logs from a specific audit policy, you may use the below syntax:
ALTER SYSTEM CLEAR AUDIT LOG FOR AUDIT POLICY “Policy Name” UNTIL ‘2021-06-15 23:59:59’;
Also, refer to the stored procedure created by Lars to simplify this activity and automate the process at: