I have created a simple C# MVC website with Entity Framework. Created a simple model, DBContext, Controller and View.
Everything works great - but as soon as I lock down the SQL User to only query the SQL View that is needed I get the following:
An exception of type 'System.Data.SqlClient.SqlException' occurred in EntityFramework.dll but was not handled in user code Additional information: CREATE TABLE permission denied in database 'MyDatabase'.
Again, everything works if the user has the CREATE TABLE permission but this shouldn't be necessary.
How to avaid that?