Question

Locked

Segregate odbc connection

By w1ljam35 ·
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.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

ODBC Permissions

by muzammil007 In reply to Segregate odbc connection

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. <a href="http://support.microsoft.com/kb/966915">KB Article</a>. I think you can give other users permission to a User DSN by tweaking registry settings. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<odbc name>, Right-click <odbc name> 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.

Collapse -

re: ODBC Permissions

by w1ljam35 In reply to ODBC Permissions

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.

Collapse -

More info

by Shellbot In reply to Segregate odbc connection

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.

Collapse -

re: More info

by w1ljam35 In reply to More info

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.

Collapse -

shame

by Shellbot In reply to re: More info

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

Back to Networks Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums