Grant user rights to create ODBC connection

Posted on 2010-01-08
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
Question by:zrod
    LVL 66

    Expert Comment

    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.....
    Can include in a startup script, a method using regini to modify permissions if it works in testing....

    Author Comment

    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
    LVL 66

    Accepted Solution

    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.....

    Author Comment

    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.
    LVL 66

    Assisted Solution

    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??

    Author Comment

    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

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
    A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
    This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
    The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now