Re: Stopping access to database outside application
- From: "Oleksandr Chuchko" <forlists@xxxxxxx>
- Date: Tue, 14 Mar 2006 20:26:24 +0200
You may do so by using application roles. Application role protected with
password and should be activated manually.
See BOL for details.
--
WBR, Evergray
--
Words mean nothing...
"Don" <Don@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A80D0068-E54C-4673-B1EC-AB847E5F2491@xxxxxxxxxxxxxxxx
Hello, I have a windows applicaton that connects to SQL Server 2000 using
Windows Authentication mode. You're granted access to the database by
being
a windows user and then the application handles the additional security.
Ie
user can view all the customer but can't modify or add new one. Or user
can
only view 10 of 100 customers in the system.
This works ok, but what if you have a creative user that somehow has
installed query analyzer or using Access to directly link to the SQL
Server
database. Is there somehow to grant someone access to a database but only
if
it's access though a certain application.
Thanks
.
- Prev by Date: Re: Sql Server login
- Next by Date: How to protect a db from an sa user fetching its schema
- Previous by thread: Sql Server login
- Next by thread: How to protect a db from an sa user fetching its schema
- Index(es):
Relevant Pages
|
