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 |
|
Lorna70
Starting Member
19 Posts |
 Posted - 2010-06-02 : 03:53:13
|
| I am rewriting an ASP.Net application to tighten up security on the SQL Server database (2005 Express). Instead of letting the app use the sa account, I have set up a new login and mapped it to a new user. I then gave execute permission on each sproc to this new user and changed the connection string in my app to use the new login. Is this the right way to go about this because my app is not working? I need to get this working asap so would appreciate your help.ThanksLorna |
|
|
|
|
|
Sprocs and user permissions