Q
Problem solve Get help with specific problems with your technologies, process and projects.

Security via authentication in Windows and authorization in SQL Server

Using Windows NT and SQL Server, what is the best way to add security by using both authentication in Windows NT and then authorization in SQL Server? And what is the best way to have record-level security for SQL tables? Is there any information on how to build Windows NT and SQL Server security using DLLs? Or is that something I would want to do?

Using Windows NT and SQL Server, what is the best way to add security by using both authentication in Windows NT and then authorization in SQL Server? And what is the best way to have record-level security for SQL tables? Is there any information on how to build Windows NT and SQL Server security using DLLs? Or is that something I would want to do?
I personally prefer SQL Server authentication over Windows authentication for what you are trying to do, though at the end of the day either will do just as well. In SQL Server 2000, most shops that want to use row-level security implement it by granting the users access only to views or stored procedures that then provide access to the underlying tables. Building your own custom security DLLs sounds like way too much work to me. I suggest you spend some time on the SQLSecurity Web site for the industry's best information on locking down and securing SQL Server.

Dig Deeper on SQL Server Security

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close