Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Permission required for deploy a dacpac

Tags:

sql

deployment

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.

like image 972
Naaruto Uchiha Avatar asked Nov 02 '22 23:11

Naaruto Uchiha


1 Answers

From here: Upgrade a Data-tier Application

Permissions

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.

like image 170
Mark Avatar answered Nov 08 '22 04:11

Mark