On my SQL Server I have the Security and Logins section.
I usually do the following to access the database from my application:
1 - Create a database on dbo scheme;
2 - Create a Login;
3 - Create a Database Role in the Database and grant the following permissions:
select, insert, update, delete, execute on schema::dbo
4 - Create a Database User and associate it to the Database role and to the Login
Then on my MVC application I use a Connection String with the login to access the database.
Can I access the database without the login?
Should I make this in some other way?
View Complete Post