# SQL Connection with Users Profile

**URL:** <https://forum.inductiveautomation.com/t/sql-connection-with-users-profile/100438>\
**Category:** Ignition\
**Created:** [January 3, 2025, 7:42pm UTC](https://forum.inductiveautomation.com/t/sql-connection-with-users-profile/100438 "2025-01-03T19:42:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anthony\_oneal](https://avatars.discourse-cdn.com/v4/letter/a/9de0a6/32.png) [@Anthony\_oneal](https://forum.inductiveautomation.com/u/Anthony_oneal)\
**Post date:** [January 3, 2025, 7:42pm UTC](https://forum.inductiveautomation.com/t/sql-connection-with-users-profile/100438/1 "2025-01-03T19:42:35Z")

</div>

Background:  
Our ignition DB connection is using windows auth and we currently have the dll in place.

Some of our in-place procs and triggers use DB level user gets.

ISSUE:  
when the simple ORIGINAL\_LOGIN() is ran from IGN it pulls the user account from the service creds.

ASK:  
Is there a way to use the logged in user creds for that session creds to sql?

---

<div class="post-metadata">

**Author:** ![Brandon\_Peterson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/brandon_peterson/32/32960_2.png) [@Brandon\_Peterson](https://forum.inductiveautomation.com/u/Brandon_Peterson)\
**Post date:** [January 3, 2025, 7:52pm UTC](https://forum.inductiveautomation.com/t/sql-connection-with-users-profile/100438/2 "2025-01-03T19:52:01Z")

</div>

Short answer: no

The way I understand Ignition's DB connections is that it always uses the credentials as they're set up on the gateway. Therefore, no matter where a data source is being used, it always has the same access as defined in the gateway config.

You'd probably want to figure out a way to send user information to the DB server manually (using that connection you've already established). At that point, it's probably more of a SQL question than an Ignition one, if that makes sense.

---

<div class="post-metadata">

**Author:** ![Anthony\_oneal](https://avatars.discourse-cdn.com/v4/letter/a/9de0a6/32.png) [@Anthony\_oneal](https://forum.inductiveautomation.com/u/Anthony_oneal)\
**Post date:** [January 3, 2025, 7:55pm UTC](https://forum.inductiveautomation.com/t/sql-connection-with-users-profile/100438/3 "2025-01-03T19:55:05Z")

</div>

I am passing the current auth user via params, but I was hoping to cheat the sql system a little and not change the current procs and triggers.

Thank you for the insight.