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?
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.
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.