Good morning,

I have an Excel application (like an end user computing app) used by employees to communicate with a remote database through ODBC calls.
The ConnectionString use a generic account and a password stored in a third-party file, when users open the Excel tool the connection is automatically refreshed.

The thing is, mainly for traceability purposes, I would like to stop using a generic account for everyone and make them using their own account to use the Excel application and pulling or pushing data from/to the database.

Do you have any ideas or guidelines to to that?
Is Integrated Windows Authentication a solution?
How to manage a unique user ID/password by user?
How to manage those uniques passwords?

Hope you'll have some advices,
Thanks mates.