disable acess to external data

[Guest]

Our SQL tables are not secure & we've found that Excel 2003 allows users to
import data from the server without having to go through the ODBC DSN
process. I tried deleting the drivers, but Excel External data function
still works. Any ideas on how to disable Excel's access to our db?

Thanks

 

[peregenem]

Our SQL tables are not secure & we've found that Excel 2003 allows users to
import data from the server without having to go through the ODBC DSN
process. I tried deleting the drivers, but Excel External data function
still works. Any ideas on how to disable Excel's access to our db?

If the user has access to the server, why not let them use Excel for
data? Turn it around, if you don't want a user to access the data then
revoke their permissions on the server.

 

[Guest]

Can't do that as they use power builder apps to read & write data to the
server. Any other ideas?

 

[peregenem]

Can't do that as they use power builder apps to read & write data to the
server. Any other ideas?

Are you say that power builder apps can't supply UID and PWD to the
server?

 

[Guest]

Are you say that power builder apps can't supply UID and PWD to the
server?

Forgot to tell you we are starting to update the power builder apps with .net and use the user name & password to authenticate access to the .net app. These are stored in tables in the sql db. Here there is no user group profiles in sql, public user has the same rights as db owner. Any other suggestions?

 

[peregenem]

Cheryl R. wrote:

<<Forgot to tell you we are starting to update the power builder apps
with .net and use the user name & password to authenticate access to
the .net app. These are stored in tables in the sql db. Here there is
no user group profiles in sql, public user has the same rights as db
owner.>>

If you success in disabling QueryTables, what about other data access
ADO, DAO, using System.Data.OleDb, etc? I think you need to secure you
database server properly.

 

[peregenem]

Cheryl R. wrote:

<<Forgot to tell you we are starting to update the power builder apps
with .net and use the user name & password to authenticate access to
the .net app. These are stored in tables in the sql db. Here there is
no user group profiles in sql, public user has the same rights as db
owner.>>

If you success in disabling QueryTables, what about other data access
ADO, DAO, using System.Data.OleDb, etc? I think you need to secure you
database server properly.

 

[Guest]

This security problem is only the tip of the iceberg. It's a long story &
I've only been here a short time & every day is a new 'adventure' Thanks for
the feedback.