1. StackOverflow 文档
  2. Microsoft SQL Server 教程
  3. 数据库权限
  4. 更改权限

更改权限

Created: November-22, 2018 

GRANT SELECT ON [dbo].[someTable] TO [aUser];

REVOKE SELECT ON [dbo].[someTable] TO [aUser];
--REVOKE SELECT [dbo].[someTable] FROM [aUser]; is equivalent

DENY SELECT ON [dbo].[someTable] TO [aUser];