实体框架代码首先迁移，sql用户权限？ [英] Entity framework code first migrations, sql user permissions?

问题描述

我天真地想到了一个sql server user / login所需的最小权限，以便能够运行实体框架代码第一个数据库迁移在模式和授予创建表上具有角色db_datareader，db_datawriter，Grant Alter的用户将是足够的。

解决方案

你需要对数据库进行以下许可。

  [db_datareader] 
 [db_datawriter] 
 [db_ddladmin] 
  

完全控制数据库使用

  [db_owner] 
  

What is the minimal permission needed on a sql server user/login for it to be able to run entity framework code first database migrations?

I naively would have thought that a user with the roles db_datareader, db_datawriter, Grant Alter on the Schema and Grant Create Table would be permissive enough.

解决方案

you need following permision on the database.

[db_datareader]
[db_datawriter]
[db_ddladmin]

For full control over database use

[db_owner]

这篇关于实体框架代码首先迁移，sql用户权限？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！