Restrict access to SQL database through ODBC

From: Chris Goddard (cjg@exel.co.uk)
Date: 06/27/02 

From: "Chris Goddard" <cjg@exel.co.uk>
Date: Thu, 27 Jun 2002 06:15:47 -0700

I have a third-party (client / server) application which
requires access through an ODBC DSN to my SQL Server
database. I would like the user's access to the database
to be restricted to this application only. Since the app
is a 3rd party app I cannot use application roles as I
have no control over the connection and therefore cannot
run sp_setapprole on that connection.

Is there any way I can use the ODBC data source but hide
it from other applications such as MSOFFICE which use
ODBC. I would also like to prevent the user from setting
up their own ODBC datasources which could point at the
database server.

Connection is using Integrated Security.

Any advice welcome.

Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Alternative to using DSN to connect to database
    ... you have to use .NET ODBC provider. ... Server is NOT optimized. ... Just because of the Admiistrator thinking DSN is easier for him to control ... > Basically my problem is that the ODBC Connection Manager in Control Panel ...
    (microsoft.public.dotnet.framework.adonet)