Re: InformixClient for Wins+Delphi+ODBC and DB security

From: Nebojsa Sevo <mips@zg.tel.hr> > >I have a client with our old legacy application with UNIX users working on >terminal emulations. All database security is in application logic. > >Now we developed new Win application using Delphi5 for management reporting >and >GUI presentation of database data ("read only" application). I installed >and >configured Informix CLI and Delphi BDE and everything is working OK. > >My problems is: > >How can I prevent PC users to install ODBC driver, connect to DB using >their >UNIX user names and passwords (they use them to run application) and use >some >tool (MS query for example) in which they can write and execute SQL >statements >DELETE, UPDATE or INSERT? Users must have table level privileges to do that >SQLs >because they are doing that in application. I just don't want that they can >do >that outside the application from PC client. > >If that isn't possible, can I log all connections coming from those clients >and >executing "destructive" SQLs. As I understand it, only OpenLink's ODBC drivers will allow you to block connections based on some sort of application ID. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.