34,587
社区成员
发帖
与我相关
我的任务
分享
USE [master]
GO
CREATE LOGIN [TUser] WITH PASSWORD=N'1', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [Test]
GO
CREATE USER [TUser] FOR LOGIN [TUser]
GO
USE [Test]
GO
ALTER ROLE [db_datareader] ADD MEMBER [TUser]
GO
use [Test]
GO
GRANT SELECT TO [数据库用户名]
GO
deny select on [表名] to [用户名]