Project Auditing to DB - why DELETE perms?

I ran into this today, I’ve setup some audit tables for a couple of my applications. I normally use a custom set of permissions for sql users and didn’t assign anything beyond insert/select for this DB.

Once I assigned it to a project and started opening/closing the project, I got some console spam for each event complaining about not having the “delete” permission.(this is running 7.7.1) Mind, the audit event inserts worked fine.


That’s because of the retention time of the profile (default 90 days):

Just as Jordan is saying. The audit log is going to delete records older than 90 days. Because of this you will need to grant permission to delete.