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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-23 : 08:16:55
|
| navid writes "We're running an application developed on ASP and the database that we're using is of MS SQL Server 2000. Right now, the application is running at 120 different sites each having individual database. Every application user has windows admin rights. Keeping these rights how can I secure the database? I mean no user can access Enterprise Manager or Query Analyzer without using windows login admin but he can run the application with the admin rights of the databases i.e 'sa'navid" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-12-23 : 08:53:18
|
| This comes from the BUILTINAdministrators group - if you drop this from the server then local admins will no longer inherit sa rights.Do a search on it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL database security using sa