创建用户、授权SCHEMA

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';

 

转载于:https://www.cnblogs.com/leo9527/p/9371194.html