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 cant ask 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 View and SP. there are a lot of Sps and views so creating a temp table and getting from there will be my last option.

Thanks