开放数据库中的某个表的特定数据的查询权限

--1. 创建登录名
USE [master]
GO
IF EXISTS(SELECT * FROM sys.syslogins AS s WHERE NAME='testUser')
BEGIN
    DROP LOGIN [testUser]   
END
GO
CREATE LOGIN testUser WITH PASSWORD=N'testUser', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
 
--2. 进入需要授权的库，创建用户名并授权
USE CA_Adhoc
GO
IF EXISTS(SELECT 1 FROM sys.database_principals WHERE NAME='testUser' AND type_desc='SQL_USER')
    DROP USER testUser
GO
CREATE USER testUser FOR LOGIN testUser
GO
GRANT SELECT ON dbo.View_2001_BI_BE_Penetration TO testUser 

--添加到角色 

exec sp_addrolemember 'db_datareader','Vikram_Read'

 

转载于:https://www.cnblogs.com/aien-Thomas/p/8520635.html