Re: Preventing an ODBC from deleting data

"brett simpson" <bsimpson@actrol.com.au> wrote in message news:<3f02543f$1_1@news.iprimus.com.au>... > Further to my query : > > Im using the informix ODBC version 2.8 > > I cant see any options to say don't delete. > > Do I need to find another 3rd party driver or try and limit the user on the > database somehow ? > > Im not sure > > thanks > > > "brett simpson" <bsimpson@actrol.com.au> wrote in message > news:3f024fd1$1_1@news.iprimus.com.au... > > How do prevent an ODBC user from deleting data ? > > > > thanks > > > > I suspect that you are looking for some degree of conditionality re. the use of DELETE across a variety of user profiles and client applications combinations. If this is the case, then you certainly need a Driver with an in-built rules engine that will allow you to set conditional DELETE privileges across your desired profiles (and enforce this server side so it cannot be violated on the client via ODBC settings reconfiguration). OpenLink's Multi-Tier Drivers will certainly offer you this sort of granularity. The Drivers are available on a free evaluation basis from http://www.openlinksw.com Kingsley Idehen OpenLink Software