Re: deny users from accessing server from Management Studio
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 25 Oct 2007 22:01:28 +0000 (UTC)
DarthSidious (DarthSidious@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I need to grant access to some users, cos' one application uses windows
integrated security but, and this is a big BUT, i don't want them to
access to sql server from management studio.... Is there any way to stop
them from accessing the server in this way? i want them to access only
from some X application. the same question goes for sql server 2000 if
there is some answer too.
No, not without changing the application. If the application requires
users to have SELECT access to tables, they have SELECT acecss from
Mgmt Studio as well.
There are ways to implement application to avoid this, for instance
using stored procedures. There are also application roles, and you
can use proxy logins.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: End SQL Session (SQL Server)
- Next by Date: Re: Password MDF
- Previous by thread: Re: deny users from accessing server from Management Studio
- Index(es):
Relevant Pages
|
|
