ODBC security
272219Jan 29 2003 — edited Jan 29 2003Is it possible to make an ODBC connection only be for a certain application? I have an application that uses an ODBC connection to connect to the database. Some of our customers use SQL Server and some use Oracle. While in our application it is necessary for the user to have the ability to read, write, delete, etc. data in the database so the security in the database allows them to do so. The problem is that they can use that user name/password to access the database via other applications such as Access, Excel, etc. using an ODBC connection. This can cause potential problems. Is there a way to limit an ODBC connection to just our application?
Any help will be greatly appreciated! Thanks!
barbara