22,301
社区成员




-- 引用
USE [Test]
GO
CREATE ROLE [AppSelectRole]
GO
use [Test]
GO
GRANT SELECT TO [AppSelectRole]
GO
USE [master]
GO
CREATE LOGIN [TestUser] WITH PASSWORD=N'123456',
DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [Test]
GO
CREATE USER [TestUser] FOR LOGIN [TestUser]
GO
USE [Test]
GO
EXEC sp_addrolemember N'AppSelectRole', N'TestUser'
GO