部署dacpac所需的权限 [英] Permission required for deploy a dacpac

问题描述

我正在尝试使用sqlpackage.exe在租户上部署dacpac。
当前，我将SysAdmin或db_owner权限授予将部署此帐户的帐户，并且它可以正常工作。
但是在生产中，如果目标租户数据库是其他应用程序的数据库，我可能没有获得这些权限，因此想知道为此所需的最低权限。

I am trying to deploy a dacpac on tenant using sqlpackage.exe. Currently I am giving SysAdmin or db_owner permission to the account which will deploy this and it works fine. But in production, if the target tenant database is of some other application, I might not get these permissions, so would like to know the minimal permission that is required for this.

推荐答案

从此处：升级数据层应用程序

权限

Permissions

只能由sysadmin或serveradmin固定服务器角色的成员或具有dbcreator固定服务器角色并具有ALTER ANY LOGIN权限的登录名升级DAC。登录名必须是现有数据库的所有者。名为sa的内置SQL Server系统管理员帐户也可以升级DAC。

A DAC can only be upgraded by members of the sysadmin or serveradmin fixed server roles, or by logins that are in the dbcreator fixed server role and have ALTER ANY LOGIN permissions. The login must be the owner of the existing database. The built-in SQL Server system administrator account named sa can also upgrade a DAC.

这篇关于部署dacpac所需的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！