Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
disable acess to external data
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 |
#2
|
|||
|
|||
Cheryl R. wrote: 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. |
#3
|
|||
|
|||
Can't do that as they use power builder apps to read & write data to the
server. Any other ideas? "Cheryl R." wrote: 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 |
#4
|
|||
|
|||
Cheryl R. wrote: 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? |
#5
|
|||
|
|||
" wrote: Cheryl R. wrote: 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? 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? |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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. |
#8
|
|||
|
|||
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. " wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
Excel 97/2000 - Help with looking up external data. | Excel Discussion (Misc queries) | |||
parameters option on the external data toolbar is not available | Excel Discussion (Misc queries) |