在服务器上保护数据库的最佳技术是什么? [英] what is the best techniques to secure database on Server ?

问题描述

我正在制作Enterprise .NET Application，我想知道什么是最好的技术来保护服务器上的数据库免受用户窃取或在SQLSVR 2008中打开，或者知道表和过程....

I''m make Enterprise .NET Application I want to know what is the best techniques to secure database on Server from user to take it or open in SQLSVR 2008 or knows table and procedures....

推荐答案

这是一个非常大的问题，取决于不同的因素，例如服务器的位置(在本地Intranet，DMZ等中)，用户身份验证模型，数据库设计，在行级别限制访问，保护备份等

我建议您从以下示例开始:保护SQL Server [ http://msdn.microsoft.com/en-us/library/ms187936.aspx [ ^ ]
- http://msdn.microsoft.com/en-us/library/ms187965.aspx [ ^ ]

This is a very large question and depends on different factors, like the location of the server (in local intranet, DMZ etc), user authentication model, design of the database, ability to restrict access on row level basis, securing backups etc etc

I suggest that you start from for example: Securing SQL Server[^].

Also have a look at these for restricting user access:
- http://msdn.microsoft.com/en-us/library/ms187936.aspx[^]
- http://msdn.microsoft.com/en-us/library/ms187965.aspx[^]

请参阅以下链接:

http://msdn.microsoft.com/en-us/library/ff648664.aspx [ ^ ]

http://www.sqlservercentral.com/articles/Administration/sql_server_security/578/ [ ^ ]

问候，
爱德华(Eduard)

See these links:

http://msdn.microsoft.com/en-us/library/ff648664.aspx[^]

http://www.sqlservercentral.com/articles/Administration/sql_server_security/578/[^]

Regards,
Eduard

看看这堆东西

浏览此 http://www.sqlsecurity.com/ [ ^ ]&在下面找到了以下这些内容
SQL安全检查表 [ SQL安全常见问题解答 [ SQL注入常见问题解答 [ SQL安全性讨论 [保护您的SQL Server数据库 [ SQL Server 2005安全最佳做法-Microsoft [ ^ ](MS Word文档)

SQL Server安全模型和安全最佳方案概述 [数据库安全问题 [ 21处提高SQL Server安全性的热门提示 [

Take a look at this bunch

Browse this http://www.sqlsecurity.com/[^] & found these following things there
SQL Security Checklist[^]
SQL Security FAQ[^]
SQL Injection FAQ[^]
SQL Security Discussions[^]

Secure Your SQL Server Database[^] It contains more than bunch of MSDN links about SQL Server security things. My favorite link.
SQL Server 2005 Security Best Practices - Microsoft[^](MS Word document)

Overview of the SQL Server Security Model and Security Best Practices[^]
Database Security Issues[^]
21 Hot Tips for Improving Your SQL Server Security[^]

这篇关于在服务器上保护数据库的最佳技术是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！