We have client app and service app, our connection string is Windows Authentication integrated security=sspi

The service app has service account so its was able to connect to db. Using Windows Authentication.

Now we need some filtration that need take Username in consideration.

I can pass Username from client app to service app. But login to db will happen with service account

When I read from ORIGINAL_LOGIN it will give service account id . but I need username.

I can’t ask the company to change the entire authentication system. this is like this due to some security measures. So I have hopping I can pass the username to db when creating a connection and have access in all my Views and SPs. There are a lot of SPs and Views so creating a temp table and getting from there will be my last option.

Thanks