数据库创建用户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'

 

posted @ 2016-04-14 16:06  talentzemin  阅读(246)  评论(0编辑  收藏  举报