# Ignition - Scripting - Database Pool - Dedicated username

**URL:** <https://forum.inductiveautomation.com/t/ignition-scripting-database-pool-dedicated-username/61521>\
**Category:** Ignition\
**Created:** [July 5, 2022, 3:24pm UTC](https://forum.inductiveautomation.com/t/ignition-scripting-database-pool-dedicated-username/61521 "2022-07-05T15:24:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![luc.martin](https://avatars.discourse-cdn.com/v4/letter/l/77aa72/32.png) [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\
**Post date:** [July 5, 2022, 3:24pm UTC](https://forum.inductiveautomation.com/t/ignition-scripting-database-pool-dedicated-username/61521/1 "2022-07-05T15:24:01Z")

</div>

I’m on 8.1.17

Database connections are pool connections and use the API username/password, I want to know if is there a way to dedicate a connection to the authenticated user instead of the API username to be able to know who made change to the db without having to specify the username for each query ?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 5, 2022, 3:28pm UTC](https://forum.inductiveautomation.com/t/ignition-scripting-database-pool-dedicated-username/61521/2 "2022-07-05T15:28:02Z")

</div>

No.

If you enable project auditing, DB updates will be automatically recorded in the audit log including the username, if known.

---

<div class="post-metadata">

**Author:** ![luc.martin](https://avatars.discourse-cdn.com/v4/letter/l/77aa72/32.png) [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\
**Post date:** [July 5, 2022, 3:41pm UTC](https://forum.inductiveautomation.com/t/ignition-scripting-database-pool-dedicated-username/61521/3 "2022-07-05T15:41:51Z")

</div>

OK, but we have lots of DB with custom APP build with Perspective, so it’s not possible to delegate the authenticated usename, or just specify username to use when we request connection.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 5, 2022, 4:41pm UTC](https://forum.inductiveautomation.com/t/ignition-scripting-database-pool-dedicated-username/61521/4 "2022-07-05T16:41:29Z")

</div>

Not through Ignition’s built in database connection mechanism, no.

You would have to script a workaround, either by manipulating your DB connections (definitely not recommended) or manually creating your own connections (also not recommended). A module would be the cleanest way to do this, but would involve some fairly significant effort.