具有 db_datareader 角色的用户对所有表具有 SELECT 访问权限.如何排除一张表? [英] A user with db_datareader role has SELECT access to all table. How do I exclude one table?

问题描述

我已将 SQL2008R02 数据库用户添加到数据读取器角色.该用户可以选择所有表.但我要他限制他在一张桌子上.我该怎么做呢?我不想在除一个表之外的所有表上单独运行 GRANT SELECT.

I have SQL2008R02 database user added to the data reader role. This user can SELECT all tables. But I want to him to restrict him from one table. How do I do this? I do not want to run GRANT SELECT individually on all tables except one.

推荐答案

您可以对一张表使用 DENY 权限，例如:

You can use a DENY permission on the one table, for example:

DENY SELECT ON myTable TO myUser

拒绝权限"在 SQL 2008 中可用.

DENY "permissions" are available in SQL 2008 onwards.

https://msdn.microsoft.com/en-GB/library/ms188338.aspx

这篇关于具有 db_datareader 角色的用户对所有表具有 SELECT 访问权限.如何排除一张表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！