数据库创建用户SQL

create login A with password='123', default_database=TableName

use TableName
create user A for login A with default_schema=dbo

exec sp_addrolemember 'db_owner', 'A'
原文地址:https://www.cnblogs.com/talentzemin/p/5391470.html