Re: Preventing an ODBC from deleting data

Michael I guess it would be a shame not to add something here after your prompt :) To answer the question, there are really two options and one of them has been highlighted already which is the grant revoke permissions. The second option is simply setting the connection on your ODBC datasource to be Read-Only. Most ODBC drivers should have this option. The only downside to this is that , if the individual making the connnection knows how to turn the option off in the datasource. That is were we have an advantage in that we have a server override option which immediately removes that possibility. HTH Emmon Michael Krzepkowski <NOmichaelkSPAM@sqlcanada.com> wrote in message news:<3F025B1B.4090909@sqlcanada.com>... > brett simpson wrote: > > >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 > > > > > Proper way would be to restrict the user on the database. > > No doubt someone from Openlink is going to add to this. > They claim to have ODBC with all kind of controls - I have not used them > - no comments. > > HTH > > Michael > > > > >"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 > >> > >> > >> > >> > > > > > > > > > > > --