MSSQL security - dening applications access to a database

Does any one know of a way to deny access to and application? Not a
user. I am trying to verify something I was told.
Someone told me it was possible to deny accesst to an application I.e.
a user and access the database with MS Query analyser but NOT MS
Access.
Does anyone know if this is possble. I can't find any documentation
that suggests it is.
Thanks in advance
BrianThe closest you can come to that is using Application Roles. More info is
found in Books Online.
Apart from that, you can of course regularly poll the system tables and
execute KILL statements for the connection who comes from not allowed
application names, but that is hardly a clean way of doing it...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Brian Anderson" <anderb@.iname.com> wrote in message
news:259a9565.0311061242.aeaa352@.posting.google.com...
> Does any one know of a way to deny access to and application? Not a
> user. I am trying to verify something I was told.
> Someone told me it was possible to deny accesst to an application I.e.
> a user and access the database with MS Query analyser but NOT MS
> Access.
> Does anyone know if this is possble. I can't find any documentation
> that suggests it is.
> Thanks in advance
> Brian