I would like to use Windows authentication on SQL Server, but so far I could not find a solution to this problem...

The application has algorithm on which rows and columns withing a table specific user allows to read or modify. To do that, on the SQL server, the user must have read/write permission on that table.

However, if the user has such permission in SQL server, they can use any ODBC connection, like via Excel...