USE [master]
GO
CREATE LOGIN [PBIAdmin] WITH PASSWORD=NPWwer020_&PBIAdmin, DEFAULT_DATABASE=[MyTestDB], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
use [MyTestDB];
GO
use [master];
GO
USE [MyTestDB]
GO
CREATE USER [PBIAdmin] FOR LOGIN [PBIAdmin]
GO
USE [MyTestDB]
GO
ALTER ROLE [db_datareader] ADD MEMBER [PBIAdmin]
GO
--------------------插入代码结束,我是分割线,嫌我烦你也可以把我删掉的哈 ----------------
关键语句: