保护SQL Server数据库 [英] Securing a SQL Server Database

问题描述

我希望保护客户端计算机中的SQL数据库不被打开或复制。

我的意思是如果有人想看到数据库结构，那么他一定不能看到它。或者，如果他试图通过将数据库复制到另一台计算机并通过SQL Server的帮助打开数据库来查看它，那么他一定不会看到它。我想保护它。



是否有任何密码保护功能，如MS Access？

请告诉我，无论如何我可以保护SQL Server数据库不被保护在未经我同意的情况下直接打开？

I want to secure an SQL Database in client's machine from being opened or copied.
I mean if anyone wants to see the database structure, then he must not be able to see it. Or else if he tries to see it by copying the database to another computer and open the database by help of SQL Server then he must not see it at all. I want to protect it.

Is there any feature to password protect it like MS Access?
Please tell me is there anyway I could protect SQL Server database from being opened directly without my consent ?

推荐答案

参考 - 安全和保护（数据库引擎） [ ^ 。在这里你会发现一切。



我想你需要身份和访问控制。

Refer - Security and Protection (Database Engine)[^]. Here you will find everything.

I guess you need "Identity and Access Control".

这篇关于保护SQL Server数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！