Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Minimum database user permissions using Entity Framework database first approach

What is the minimum set of database user permissions in SQL Server using Entity Framework database first approach in an ASP.NET MVC app?

Is it only read and write or does EF need some more advanced permissions?

like image 807
Santhos Avatar asked Feb 10 '26 01:02

Santhos


1 Answers

We typically use the following permissions

Db Access admin, Db data reader And db data writer.

These were sufficient in most cases.

like image 110
Saravanan Avatar answered Feb 12 '26 15:02

Saravanan



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!