USE master
GO
CREATE LOGIN user_bfp WITH PASSWORD=‘He1108392‘
GO
CREATE USER user_bfp FOR LOGIN user_bfp WITH DEFAULT_SCHEMA=user_bfp
GO
/*用户授权*/
EXEC sp_addrolemember N‘db_accessadmin‘, N‘user_bfp‘;
EXEC sp_addrolemember N‘db_owner‘, N‘user_bfp‘;
GO
USE [SSPC_EDT_DB]
GO
CREATE USER user_bfp FOR LOGIN user_bfp WITH DEFAULT_SCHEMA=user_bfp
GO
CREATE SCHEMA user_bfp AUTHORIZATION user_bfp
GO
EXEC sp_addrolemember N‘db_accessadmin‘, N‘user_bfp‘;
EXEC sp_addrolemember N‘db_owner‘, N‘user_bfp‘;
创建用户、授权SCHEMA
原文：https://www.cnblogs.com/leo9527/p/9371194.html
