Entity Framework Core - Database.Migration()

Question

I would like to ask you if it is possible to proceed (in entity framework core):

context.Database.Migrate();

using database user without ddladmin permissions?

What I would like to achieve:

User without permission should not update migrations (without errors). However users with those kinds of permissions should be able to make migrations.

Currently, I am getting this kind of errors:

System.Private.CoreLib: Exception while executing function: xxx. Core Microsoft SqlClient Data Provider: CREATE TABLE permission denied in database 'xxxx'.

I don't understand your question. You want to avoid the Migration if the user don't have the permission? — Sean Stayns
– Sean Stayns, Commented Apr 20, 2021 at 9:58
If user does not have ddladmin permission he gets "Create Table permission" error. — azuremycry
– azuremycry, Commented Apr 20, 2021 at 10:01

Sean Stayns · Accepted Answer · 2021-04-20 13:54:18Z

1

You have two options:

You give the user the db_ddladmin role
You add the create table grant to the user, like GRANT CREATE TABLE TO Joe AS dbo

I think the second one is what you are looking for.

answered Apr 20, 2021 at 13:54

Sean Stayns

4,2646 gold badges27 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Flater Over a year ago

Note that migrations entail more than just table creation.

Collectives™ on Stack Overflow

Entity Framework Core - Database.Migration()

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related