?
Solved

Grant user rights to create ODBC connection

Posted on 2010-01-08
8
Medium Priority
?
3,567 Views
Last Modified: 2013-12-14
Is there a way to grant a normal user who is not an administrator, teh righ to create and edit ODBC connections in windows 2008 Server
0
Comment
Question by:zrod
  • 3
  • 3
6 Comments
 
LVL 66

Expert Comment

by:johnb6767
ID: 26300546
Are you referring to a deployable method?
I might think you could have a local user, on a machine, restricted user, edit them by granting "Full Control" to the following reg key.....
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
Can include in a startup script, a method using regini to modify permissions if it works in testing....
0
 

Author Comment

by:zrod
ID: 26301538
the situation is teh following:
We have users working on an application that is already deployed.
The application have to create an ODBC for some users during runtime. This application is launched by teh user himself
0
 
LVL 66

Accepted Solution

by:
johnb6767 earned 2000 total points
ID: 26310202
Test out modifying the permissions on the above key.... You can also have the users create User DSNs. Shouldnt be a problem on a restricted user.....
1
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 

Author Comment

by:zrod
ID: 26322243
thank you.
thats solve 90% of teh problem.
what is remaining, is taht other applications like excel, does not see this ODBC connection while running building a query in MSquery.
0
 
LVL 66

Assisted Solution

by:johnb6767
johnb6767 earned 2000 total points
ID: 26328499
If it is a System DSN, theres no reason it should not see it..... Unless the ODBC connection is created while the app is open??
0
 

Author Comment

by:zrod
ID: 26340741
In fact what uis happening, is that we are able to view the User DSN, and not teh system DSN.
In all cases i will consider teh question as closed and accept the solution
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
The article covers five tools all IT professionals should know about, as they up productivity by a great deal!
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question