如何保护sql server 2005 MDF文件 [英] How to protect the sql server 2005 MDF file

问题描述

如何设置 sql server 2005 MDF 文件的密码.

How to set the Password for sql server 2005 MDF file.

因为我想把路径包给客户，包包括 MDF.

Becoz i want to give the trail package to the client,package including the MDF.

安装包后，MDF 将放置在 C 盘，用户数据将通过应用程序存储在 MDF 文件中.但不允许在该系统中使用 sql server 附加该 MDF 文件.

After installing the package, the MDF will be placed in C drive, user data will store in MDF file through the application. but not allow to attach that MDF file using sql server in that system.

推荐答案

如果某人是某个实例的系统管理员，那么无论您做什么，他都可以附加 mdf.如果你想保护系统管理员的数据，有一些技巧是可能的，但它是相当困难的.如果您想阻止大多数人(数据库所有者和系统管理员除外)连接到数据库，请实施基于角色的安全性，您可以在其中定义哪些角色可以和不能对数据库中的数据执行操作.您还可以查看应用程序角色，它们可能对您有用.

If someone is sysadmin of an instance, one will be able to attach the mdf regardless of what you do. If you want to protect data from sysadmin, there are some tricks possible but it is rather hard. If you want to prevent most of the people (with exception of owner of database and sysadmin) from connection to database, implement role based security, where you can define what roles can and cannot do with data in database. You can also look at application roles, they may be useful for you.

这篇关于如何保护sql server 2005 MDF文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！