"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