Hide ODBC linked table connection information (username and password specifically)

[Oren]

Hi,

Is there a way to hide the connection information of linked SQL Server
tables from users? It's easy to open a system table and find the
connection info, and if the username and password are saved with this
info, anyone could potentially access this information.
Much thanks,
Oren

[David Schofield]

On 20 Jan 2005 17:00:40 -0800, "Oren" <or**@gdblegal.com> wrote:

Hi,

Is there a way to hide the connection information of linked SQL Server
tables from users? It's easy to open a system table and find the
connection info, and if the username and password are saved with this
info, anyone could potentially access this information.
Much thanks,
Oren

Hi
My ODBC connect strings don't have any user or password information in
them. Though thinking about it I am using db2 at present which takes
authorisation from the network user account. However, can't you make
the connection explicitly in code before calling any of the tables?
David

[Terrell Miller]

Oren wrote:

Hi,

Is there a way to hide the connection information of linked SQL Server
tables from users? It's easy to open a system table and find the
connection info, and if the username and password are saved with this
info, anyone could potentially access this information.
Much thanks,
Oren

Oren, if you have set up an ODBC data source (Control Panels,
ADministrative Tasks) using WIndows authentication to connect to the
source (SQL Server database, f'rinstance), then all you need to do to
link to the ODBC source is to choose ODBC Driver from teh drop-down in
your Link Tables window, and select the data source you set up.

IIRC that does not show the userID or password when you mouseover the
linked table icon in teh database window.

--
Terrell Miller
mi******@bellsouth.net

"Every gardener knows nature's random cruelty"
-Paul Simon RE: George Harrison

[Oren]

Terrell,

Thanks for your reply, but I'm not sure if I get it.
I did create an ODBC data source which uses Windows authentication.
If I don't store the username & password with the linked table, then
the user is prompted for them the first time one of the tables is
accessed.
If they are stored with the table, I've noticed that in some systems
the connection string shows up when hovering; in others it doesn't. But
in both types of systems, a simple query like:

SELECT * FROM MSysObjects

gives you all of the information about the database objects, including
linked table connection strings (revealing the uname/pswd).

Is there something that I'm missing here?

Thanks,
Oren

Terrell Miller wrote:

Oren, if you have set up an ODBC data source (Control Panels,
ADministrative Tasks) using WIndows authentication to connect to the
source (SQL Server database, f'rinstance), then all you need to do to link to the ODBC source is to choose ODBC Driver from teh drop-down in your Link Tables window, and select the data source you set up.

IIRC that does not show the userID or password when you mouseover the linked table icon in teh database window.

--
Terrell Miller
mi******@bellsouth.net

"Every gardener knows nature's random cruelty"
-Paul Simon RE: George Harrison