限制对数据库的访问
如何限制用户对我安装到管理工作室的数据库的访问权限，仅允许某些人（可能是我一个人）访问？
但当我看到我安装到客户端电脑的数据库能够使用窗口身份验证打开时，我感到惊讶。我认为它只能由我为该数据库创建的新用户打开。
那么如何删除使用窗口身份验证的登录用户查看的数据库。
how do I limit the user access to the database I installed to the management studio for only certain people(probably me alone) to access?
But I got a surprise when I saw the database I installed to my client pc was able to be opened using window authentication. I thought it is only able to be opened by the new user I created for that database.
so how do I remove the database from being viewed by those login using window authentication.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
在 SQL Management Studio 中，转到“安全性”。您很可能会在其中找到一些 Windows 帐户。这是正常行为，它们是在安装 SQL 实例时放置在那里的。
您可以做的就是删除那些您不想在数据库中查看的内容。 确保您至少保留1 名数据库管理员。
您还可以限制他们的只读访问权限。请阅读这篇文章了解如何创建/编辑用户。转到要编辑的用户的属性，然后转到“管理服务器角色”。了解有关服务器角色的详细信息
In the SQL management studio go to "Security". Its quite possible that you will find some Windows accounts in there. This is normal behavior and they are put there on installment of the SQL instance.
What you can do is delete the ones you don't want poking around in the DB. Make sure that you at least keep 1 db administrator.
You can also restrict their access to read_only. Read this article on creating/editing users. Goto the properties of the user you want to edit and goto "Manage Server Roles". Learn more about server roles here