Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

Restrict ODBC Access

Bernd Huber
Occasional Contributor

Restrict ODBC Access

we are having a security concern. We are running HP-UX 11.00 and a progress database version 8.6C with MFGPro as an interface.

We realized today that every user having a unix account can establish an ODBC connection to our database - little desirable.
Now the question came up, how can we allow only selected user to access our databases on a Unix level ?

Thank you very much for all the help in advance !

Victor Geere
Frequent Advisor

Re: Restrict ODBC Access

If nothing else prevents you from doing this, you can authenticate users in the database using their OS credentials. Then set the priveleges in the database for each OS user.

Alternatively issue each database user with a unique database userid and set the priveleges for these at a database level.

You might also want to create a OS group with access to the OS directory where the database is situated and only add the users that have access to the database to prevent anyone from circumventing the database security and doing something really bad.

What type of authentication are you using for the ODBC driver?
I thought that I was because I had thought.