数据库只能由数据库所有者访问 [英] Database should be only accessible to the owner of the database

问题描述

朋友们，

我已经在sql server 2005中创建了一个新用户，并通过该登录名创建了一个数据库，现在我有了一个要求，该数据库应该仅对数据库所有者可见或可访问，我的意思是创建数据库的人. Windows登录和SA登录也可供其他用户访问.谁能帮我...


在此先感谢....

Hi friends,

I have created a new user in sql server 2005, and created a database by this login, Now i have a requirement , the database should be visible or accessible only to the owner of the database i mean the who created the database.It should not be accessible to the other users even windows logins and SA login. Can any one help me...


Thanks in Advance....

推荐答案

不，我们不能.

SA登录名是超级用户-它可以查看并执行任何喜欢的操作.这就是为什么将其用于日常日常工作被认为是一个非常糟糕的主意的原因. 您无法向超级用户隐藏数据库.

No, we can''t.

SA login is a superuser - it can see, and do, anything it likes. That is why is is considered a very bad idea to use it for normal everyday tasks.
You cannot hide a database from a superuser.

这篇关于数据库只能由数据库所有者访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！