如何为数据库文件使用密码(SQL SERVER MDF) [英] how to using password for database file (SQL SERVER MDF)

问题描述

我如何在数据库文件上使用密码?

How i Can use Password on my Database File?

推荐答案

应用密码非常简单:^ ]，但正如您所说的那样，它可能会做您想要的事情，因为它不会阻止任何人将文件作为字节流读取.

您可能还希望/而不是考虑使用加密.

Applying a password is pretty simple: http://msdn.microsoft.com/en-us/library/ms171741(v=sql.90).aspx[^] but as it says, that may ot do what you want, as it does not prevent anyone from reading the file as a byte stream.

You might want to consider encryption as well / instead.

您是否正在要求一种分离数据库文件或使用数据库时对数据库文件进行加密的方法.如果要确保对静态数据进行加密"，可以查看SQL Server 2008透明数据加密(TDE).

TDE不仅比基本密码复杂一点，它还包括证书，密钥，密码等.不幸的是，它仅限于SQL Server 2008 +

这是链接:
了解透明数据加密(TDE) [

Are you asking for a way of encrypting the database files after they have been detached or while the db is in use. If you want the ensure "encryption for data at rest" you can look at SQL Server 2008 Transparent Data Encryption (TDE).

TDE is a little more complex than just a basic password, it includes certificates, keys, passwords, etc. It is unfotunately limited to SQL Server 2008 +

Here is the link:
Understanding Transparent Data Encryption (TDE) [^]


I hope this helps.

这篇关于如何为数据库文件使用密码(SQL SERVER MDF)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！