使用ARM模板将用户添加到SQL Azure数据库 [英] Adding Users to SQL Azure Database with ARM template
问题描述
我正在尝试在数据库内部创建用户,并为每个用户授予一些特定的权限;借助ARM模板.但是我找不到使用ARM的方法.
I am trying to create users inside DB and grant some specific permission each user; with the help of ARM template. But I do not find a way to do it using ARM.
有人可以告诉我ARM模板是否支持
Can someone tell me is it supported by the ARM templates to
- 创建数据库用户并授予权限?
- 是否支持将Dacpac部署到数据库?
推荐答案
据我所知,您无法使用ARM模板将用户插入数据库.我已经仔细观察了-如果我错了,有人可以纠正我.
You can't insert users into a database using an ARM template to my knowledge. I've looked pretty closely - someone correct me if I'm wrong.
关于将数据导入系统的能力,VSTS Build具有一些选项.
As for the ability to get data into the system, you have some options with VSTS Build.
-
您可以使用Powershell任务来调用 invoke_sqlcmd ,您可以使用自己的脚本插入用户.
You can use a Powershell task to call invoke_sqlcmd, which you can insert users using your own script.
我个人最喜欢的是Azure SQL数据库部署任务,它将部署DACPAC.在DACPAC中,您可以根据需要设置用户.
My personal favorite is the Azure SQL Database deployment task, which will deploy a DACPAC. In the DACPAC you can set up users as needed.
这篇关于使用ARM模板将用户添加到SQL Azure数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!