是否可能密码保护SQL服务器数据库,甚至从服务器的管理员? [英] Is it possible to password protect an SQL server database even from administrators of the server?
问题描述
我想安装一个应用程序(ASP.Net + SQL server 2005 express)在一些小公司的本地网络演示它一段时间,但我也希望没有人甚至sysadmin 有没有对这个数据库的权限和任何权限授予想要一个安全的通行证,我有。
我只是希望我的表结构和关系和函数隐藏和加密数据没有优势
I want to install an application (ASP.Net + SQL server 2005 express) in local network of some small company for demoing it for a period of time, but I also want nobody even sysadmin have no permission on this database and any permission granting wants a secure pass that I have . I just want my tables structure and relations and functions be hidden and encrypting the data have no advantage
我需要花更多的时间在这篇文章 SQL Server 2008中的数据库加密企业版 从此回答是可能的-to-password-protect-an-sql-server-data
I need to spend more time on this article Database Encryption in SQL Server 2008 Enterprise Edition that i found from this answer is-it-possible-to-password-protect-an-sql-server-database
但
1 。我想要更清楚一点,因为其他答案在此页面中说:
1.I like to be sure and more clear on this because the other answer in this page says :
是的。除了
服务器的管理员之外,您可以保护它不受所有人
的约束。
Yes. you can protect it from everyone except the administrators of the server.
3.有没有其他可能的解决方案和解决方法?
3.is there any other possible solutions and workaround for this?
4.如果我使用自己的sa密码安装新实例,我可以限制其他实例管理员将mdf附加到自己的密码吗?
4.if I install a new instance with my own sa password , can i restrict other instances admins from attaching the mdf to their own ?
推荐答案
无论你做什么,这些人都可以访问你的服务器或SQL Server实例
These people can access your server or the SQL Server instance no matter what you do
- 任何有权访问服务器的人
- 网络域管理员
- 任何拥有sa密码的人
- 具有本地管理员和/或sa权限的Windows群组(这意味着群组政策等)
- anyone with physical access to the server
- domain admins of the network
- anyone with the sa password
- a windows group with local admin and/or sa rights (which implies group policy etc)
如果您不想登录,您必须将您的服务器托管在非现场。
You have to host your server offsite if you want no-one to get to log onto it.
这是 简单
这篇关于是否可能密码保护SQL服务器数据库,甚至从服务器的管理员?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!