Azure database

  1. 创建数据库用户 
 1 CREATE LOGIN LoginName
 2 WITH PASSWORD = '123456' 
 3 GO
 4 
 5 -- For login <login_name, sysname, login_name>, create a user in the database
 6 CREATE USER LoginName
 7 FOR LOGIN LoginName
 8 WITH DEFAULT_SCHEMA = dbo
 9 GO
10 
11 -- Add user to the database owner role
12 EXEC sp_addrolemember N'db_owner', N'LoginName'
13 GO

 

posted on 2018-06-25 09:22  木龙哥  阅读(311)  评论(0)  编辑  收藏  举报

导航