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 VBA etc. to access the server and they would get full access to all data in the table.
Is there a way to go around this?
Thanks
Shraga