By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,027 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,027 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.