Preventing an ODBC from deleting data

How do prevent an ODBC user from deleting data ? thanks

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 > >

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 >> >> >> >> > > > >

Hmmmm How do you restrict the user on the database ? Im not sure how to do it ? 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 > >

worked it out. what I did : grant connect to the database for the user get all tables from systables with a tabid > 100 revoke all on the obtained tables grant select on the obtained tables this seems to work well. 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 > >