SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 06:05 PM
| |||
| |||
 Re: Preventing an ODBC from deleting data 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 > >      |
|
04-19-2008, 06:05 PM
| |||
| |||
| Re: Preventing an ODBC from deleting data 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 >> >> >> >> > > > > |
|
04-19-2008, 06:05 PM
| |||
| |||
| Re: Preventing an ODBC from deleting data 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 > > |
|
04-19-2008, 06:06 PM
| |||
| |||
| Re: Preventing an ODBC from deleting data Easy - revoke sql delete privlage from specific username and use UID=username in the ODBC connection string when connecting to the database instance. Same for OLE-DB. Noel "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 > > |
|
04-19-2008, 06:07 PM
| ||||
| ||||
| 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 |
 |
« Re: book
|
Re: C on Solaris »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:04 AM.
