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?

Best regards

Related posts

Recent Viewed