use master exec sp_droplogin 'sa2' use [用户数据库] exec sp_addlogin 'sa2','123456' exec sp_adduser 'sa2','admin2017','db_owner'