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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
In all cases i will consider teh question as closed and accept the solution
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\SOFTWAR
Can include in a startup script, a method using regini to modify permissions if it works in testing....