# Project Auditing to DB - why DELETE perms?

**URL:** <https://forum.inductiveautomation.com/t/project-auditing-to-db-why-delete-perms/9841>\
**Category:** Ignition\
**Created:** [March 25, 2015, 5:04pm UTC](https://forum.inductiveautomation.com/t/project-auditing-to-db-why-delete-perms/9841 "2015-03-25T17:04:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [March 25, 2015, 5:04pm UTC](https://forum.inductiveautomation.com/t/project-auditing-to-db-why-delete-perms/9841/1 "2015-03-25T17:04:00Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 25, 2015, 6:46pm UTC](https://forum.inductiveautomation.com/t/project-auditing-to-db-why-delete-perms/9841/2 "2015-03-25T18:46:13Z")

</div>

That’s because of the retention time of the profile (default 90 days):  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/aa267fd0f59e65455dbe964aee17508a7592fe2b.png)

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [March 27, 2015, 6:39pm UTC](https://forum.inductiveautomation.com/t/project-auditing-to-db-why-delete-perms/9841/3 "2015-03-27T18:39:15Z")

</div>

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.