By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,934 Members | 1,528 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,934 IT Pros & Developers. It's quick & easy.

Using Windows Authentication via application without opening it to users

P: 1
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?


Sep 15 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,430
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.
Sep 16 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.