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 |
|
dallsop
Starting Member
1 Post |
 Posted - 2007-04-12 : 13:11:17
|
| I have a database on an SQL 2000 server with about 250 users. The only intended medium of connecting to this database is two proprietary applications that connect using microsoft ODBC links. Some users have been connecting to the database using microsoft Access or Excel and started messing up with the tables. My question is; is there a way of allowing only certain applications to connect? This way I would be able to disallow Access from making a connection. I do see that in the activity monitor I can see which applications people are using to connect with. And so think there might be a way to do this. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-12 : 13:22:08
|
| I suppose you could write a KILL script that would check sysprocesses to determine who to disconnect. You could then have this script run say every minute.But the way to handle this is to have your applicatoins connect using an application userid and not with individual user accounts. Then you don't ever give out the application userid password. This would mean that your application would need to handle application security for the users though, so it would be a large code change.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Appliaction Filter