Project Auditing to DB - why DELETE perms?

Ignition
1

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.

Intended?

2

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

3

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.