34,594
社区成员
发帖
与我相关
我的任务
分享
USE [master]
GO
CREATE LOGIN [A] WITH PASSWORD=N'1', DEFAULT_DATABASE=[Test], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [Test]
GO
CREATE USER [A] FOR LOGIN [A]
GO
USE [Test]
GO
ALTER USER [A] WITH DEFAULT_SCHEMA=[A]
GO
USE [Test]
GO
CREATE SCHEMA [A] AUTHORIZATION [A]
GO
USE [master]
GO
CREATE LOGIN [B] WITH PASSWORD=N'1', DEFAULT_DATABASE=[test], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [Test]
GO
CREATE USER [B] FOR LOGIN [B]
GO
USE [Test]
GO
ALTER USER [B] WITH DEFAULT_SCHEMA=[B]
GO
use [Test]
GO
GRANT CREATE TABLE TO [A]
GO
GRANT CREATE TABLE TO [B]