Link to home
Start Free TrialLog in
Avatar of zrod
zrod

asked on

Grant user rights to create ODBC connection

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
Avatar of johnb6767
johnb6767
Flag of United States of America image

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....
Avatar of zrod
zrod

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of johnb6767
johnb6767
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of zrod

ASKER

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of zrod

ASKER

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