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 |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-09-27 : 06:16:09
|
| We are using SQL Server 2005 EE in our client place. databases accessed by web application. this application accessing OLTP database using sql server user login. currently the sql login has sysadmin permission. for security reason this is not good. so which server roles and database roles will enough for the application use a OLTP database.--Ragu |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-09-27 : 06:57:35
|
| Absolutely no way to say. You need to sit down and figure out what that app does, what objects it needs access to and what permissions it needs. This is a non-trivial job.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Permission