Preventing an ODBC from deleting data

Posted in 2003

Summary

brett simpson asked how to stop an ODBC user (Informix ODBC 2.8) from deleting data. Michael Krzepkowski advised restricting the user in the database rather than in the driver. brett then solved it himself: granted connect, revoked all on the tables found in systables with tabid above 100, and granted select on them.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Connectivity: ODBC / JDBC / .NET

brett simpson — Wed, 2 Jul 2003 13:21:02 +1000 — source: Usenet: comp.databases.informix

How do prevent an ODBC user from deleting data ? thanks

↪ replying to brett simpson

brett simpson — Wed, 2 Jul 2003 13:39:56 +1000 — source: Usenet: comp.databases.informix

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

↪ replying to brett simpson

Michael Krzepkowski — Wed, 02 Jul 2003 04:10:26 GMT — source: Usenet: comp.databases.informix

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

↪ replying to brett simpson

brett simpson — Wed, 2 Jul 2003 14:22:03 +1000 — source: Usenet: comp.databases.informix

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

↪ replying to brett simpson

brett simpson — Wed, 2 Jul 2003 15:24:08 +1000 — source: Usenet: comp.databases.informix

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