# User.id via Database User Source

**URL:** <https://forum.inductiveautomation.com/t/user-id-via-database-user-source/111069>\
**Category:** Ignition\
**Created:** [September 29, 2025, 6:38pm UTC](https://forum.inductiveautomation.com/t/user-id-via-database-user-source/111069 "2025-09-29T18:38:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![meverly](https://avatars.discourse-cdn.com/v4/letter/m/bc79bd/32.png) [@meverly](https://forum.inductiveautomation.com/u/meverly)\
**Post date:** [September 29, 2025, 6:38pm UTC](https://forum.inductiveautomation.com/t/user-id-via-database-user-source/111069/1 "2025-09-29T18:38:52Z")

</div>

Is there a way to specify the user.id when writing the queries for a manual Database User Source? Inside my session props you can see the id and userName are the same. I need the id to be the column jdeEmployeeId in my auth.Person table, while the userName can stay as is (auth.Person.personId). I know the column naming is confusing, sorry.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/1/31b1cc9bfc5c2e6797be01ead0d63744b8a550a4.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/c/6c45a10ba40ca5f2baa1beaaf9ef2d762eedde7a.png)

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/d/6da2618c3ca7f5e4e5ef69dd3024467f2580a970.png)

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [September 29, 2025, 6:56pm UTC](https://forum.inductiveautomation.com/t/user-id-via-database-user-source/111069/2 "2025-09-29T18:56:25Z")

</div>

Post the actual queries with formatting. (Use the `</>` button)

---

<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:** [September 29, 2025, 7:01pm UTC](https://forum.inductiveautomation.com/t/user-id-via-database-user-source/111069/3 "2025-09-29T19:01:20Z")

</div>

If you're on 8.3, you can return a column named `useruuid`, and we'll use whatever string value you return as the user's "id" property.

I don't think a similar capability exists for 8.1.

---

<div class="post-metadata">

**Author:** ![meverly](https://avatars.discourse-cdn.com/v4/letter/m/bc79bd/32.png) [@meverly](https://forum.inductiveautomation.com/u/meverly)\
**Post date:** [September 29, 2025, 8:16pm UTC](https://forum.inductiveautomation.com/t/user-id-via-database-user-source/111069/4 "2025-09-29T20:16:44Z")

</div>

Unfortunately I am on 8.1. So the id just defaults to be the same as the userName in 8.1? I suppose I’ll need to update the userName to come from the jdeEmployeeId column then.

---

<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:** [September 29, 2025, 9:13pm UTC](https://forum.inductiveautomation.com/t/user-id-via-database-user-source/111069/5 "2025-09-29T21:13:40Z")

</div>

Yes, in 8.1 whatever username was supplied in the query is what will be returned as the ID.