SQL Server DB的安全性 [英] Security of SQL server DB

问题描述

我有一些SQL服务器数据库附加到我的实例。问题是它们可以很容易地从物理文件夹中复制，任何人都可以将它们附加到自己的实例并查看数据。



如何确保文件夹时是附加的，它们不能从物理位置复制，只有在与实例分离时才能复制？



谢谢

Hi,
I have some SQL server DBs attached to my instance. The problem is they can easily be copied from the physical folder and any one can attach them to his own instance and view data.

How can I make sure that when files are attached, they can not be copied from the physical location and can be copied only when detached from the instance?

Thanks

推荐答案

查看此链接





http://social.msdn.microsoft.com/Forums/sqlserver/en-US/64767924- 40e6-46c1-88ee-71ff49953e61 /数据库阻止附件 [ ^ ]

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