Question Locked

Segregate odbc connection

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to show certain odbc connections only to specific users on a terminal server. For example, I have an Access db that has an sql back-end. All users can see the production database. I would like the development team to be able to see the test db without the regular users being able to see it. Currently all odbc connections are in the system dsn so everyone can see all of them. Is there are way, maybe using file or user dsn that I can accomplish this? Thanks.

6 replies

by muzammil007

Hi, I'm a newbie on TechRepublic. I did a little research on your topic. As per my understanding, Here is an article that explains System DSN vs User DSN. KB Article. I think you can give other users permission to a User DSN by tweaking registry settings. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\, Right-click select permissions, and add a user to permit access to User DSN. Let me know if this is what you are looking for. Trying to learn new things, So I apologize if I'm incorrect.

by w1ljam35

This is exactly the kind of info I'm looking for. What I would like to do is grant a group of users access to a user or file dsn. I will try the registry tweak you suggested. Thanks.

by shellbot

A dsn is just a mapping..

Are you using Integrated authentication?
If so, you can set your DB permissions per user in SQL.

Are you managing users through groups?
For example, I use Active Directory groups and then in the DB either give or deny permission to certian groups for certian DB's.

by w1ljam35

Unfortunately, SQL authentication is all that is available to me. I am managing users through groups so I'd like to figure out if I can give a group access to a file dsn. Isn't that what they're for? I've never used one but that what the description suggests. Thanks.

by shellbot

so much easir with integrated authentication :(

well, give it a go and let us know how it works out ok..or if ye need more help

This discussion is closed to new replies.