Using Windows Authentication via application without opening it to users

[Shraga]

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

[Rabbit]

Edit: Your thread has been moved to the SQL Server forum because that's what you're asking about, not .Net.

SQL Server doesn't really have row level or column level security.

You can replicate row level security by locking down the original table and using a restricted view that returns the allowed rows.

As for column level security, that can't really be done in SQL Server. The only thing you could really do is take the concept above and create a different view for each group.