Re: Accesing data from many applications.

On Feb 24, 11:28 am, MariaGuzman <mar...@xxxxxxxxxx> wrote:
Hi, I have a server running sql server 2000 sp3. In this sql server we
use windows authentication to allow users to use the applications that
were developed in house.

At this moment we have some users that are using excel to get data from
databases but we don´t want they do that, because we can´t control the
data they are getting.

We want to restrict that all users can get data only using the
applications that are developed in house.

Do you know if in sql server I can restrict wich applications can be
connected to sql server and wich not??

I need to continue using windows authentication.

Thanks a lot for your help.

*** Sent via Developersdexhttp://www.developersdex.com***

If a user has permission to connect they can.
See SQL Server 2005 Books Online topic:
Application Roles

.

Relevant Pages

  • Re: Accesing data from many applications.
    ... applications that are developed in house. ... Do you know if in sql server I can restrict wich applications can be ... I assume here that your applications are not using stored procedures, ...
    (microsoft.public.sqlserver.security)
  • Accesing data from many applications.
    ... I have a server running sql server 2000 sp3. ... applications that are developed in house. ... Do you know if in sql server I can restrict wich applications can be ... I need to continue using windows authentication. ...
    (microsoft.public.sqlserver.security)
  • detecting group of logins
    ... I have some applications that talks with sql server. ... In all of them they are use windows authentication. ... there a way to know what login the user tried to access? ...
    (microsoft.public.sqlserver.security)
  • Re: Application Security
    ... these Windows Forms applications, ASP.NET applications, Windows services, or ... I assume that your C# clients are not distributed to end users. ... > There is a global SQL Server userid and password. ...
    (microsoft.public.dotnet.security)
  • Re: Quorum Disk or Majority Node?
    ... LOT of 3rd party applications where every issue is always blamed on ... See "Sizing a Majority Node Set Cluster" ... When SQL Server 2005 starts supporting database mirroring there is ... SQL Server does not NATIVELY support MNS clustering. ...
    (microsoft.public.sqlserver.clustering)