如何为用户禁用 SQL Server Management Studio [英] How to disable SQL Server Management Studio for a user

问题描述

有没有办法阻止用户进入 SQL Server Management Studio，这样他们就不能手动编辑表行?他们仍然需要通过运行我的应用程序来访问这些表.

Is there a way to prevent users from getting into SQL Server Management Studio so that they can't just edit table rows manually? They still need to access the tables by running my application.

推荐答案

您不必担心他们是否可以访问该工具.只需确保他们不知道具有读/写权限的特定数据库的任何 SQL 登录名，如果知道，请更改密码.如果他们可以通过 Windows 身份验证访问数据库，请确保他们处于 datareader 角色.您可以使用角色来管理用户可以在 SQL 中执行的操作.

You DO NOT need to worry about them having access to the tool. Simply make sure they do not know any of the SQL logins for the specific Databases that have read/write permissions, if they do, change the password. If they have access to the DB via Windows Authentication, make sure that they are in a datareader role. You can use roles to manage what the users can do in SQL.

这篇关于如何为用户禁用 SQL Server Management Studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！