Proposal for Implementing Audit Rotation Policies

[gianpaolo-tndigit]

Currently, AAC utilizes the "Audit" table to log events generated during its operation.
Given the importance of maintaining a manageable and efficient audit trail, it prompts the question:

• would it be feasible and beneficial to introduce Audit Rotation Policies within?

Implementing such policies could involve defining rules or criteria for rotating and archiving audit logs based on factors like size, age, or event frequency.