Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2010-09-14 : 06:32:00
|
| Hello,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::dbo4 - 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?Thank You,Miguel |
|
|
|
|
|
Login and Securiry