Is it possible to deny access to SQL Server from specific programs?
Posted
by Paul McLoughlin
on Stack Overflow
See other posts from Stack Overflow
or by Paul McLoughlin
Published on 2010-05-19T15:43:35Z
Indexed on
2010/05/19
15:50 UTC
Read the original article
Hit count: 158
sql
|sql-server-2008
Currently one of our databases (SQL Server 2008) is accessed via a number of different mechanisms: .Net SqlClient Data Provider; SQL Server Management Studio; various .Net applications and 2007 Microsoft Office system (basically Excel).
I see that in the sys.dm_exec_sessions DMV it is possible to see the program name of the program accessing the database for the current sessions. My question is: is it possible for one to deny access from a particular named program? First prize would be if this could be done for any named program, but we would gain a great deal of benefit from being able to deny access to this specific database from all Microsoft Office applications (especially Excel).
© Stack Overflow or respective owner