Re: Re[2]: ODBC with informix

Hi As I told you before, use Openlink ODBC drivers. It is possible. With Openlink you can restrict a user to readonly access. It looks like this is what you need. You can also let Openlink change the user ID to a restricted Informix User. Many more features. Get a trail copy at www.openlinksw.com Hannes Visagie Sujit.Pal@alltel.com wrote in article <6ekdj2$j2n$1@news.xmission.com>... > > Jay > > Is it not possible to setup different roles for a non-ODBC and a ODBC > role? The non-ODBC role could come in through a Unix login and have > his login shell out directly to the application and have all the > permissions or as many as required. The ODBC role could have no > INSERT/DELETE/UPDATE permission since possibly the intent is for him > to populate his Excel spreadsheet to run some offline analysis or > something similar. > > When getting into the application under Unix, the ROLE could be set to > the non-ODBC role and the ODBC could set role to ODBC user. > > I am thinking of implementing something along these lines, so I would > appreciate any holes you can find in my thinking. > > Thanks > > Sujit Pal > > > ______________________________ Reply Separator _________________________________ > Subject: Re: ODBC with informix > Author: Jay Hannah <jay@jays.net> at Internet > Date: 3/13/98 7:08 PM > > > Killspamrs wrote: > > Along this line, but completely different, in an NT/win 95 environment is it > > possible to completely disable all ODBC connectivity from within Informix? I > <snip!> > > Since syscolsauth will say they have add/change/delete god knows what they > > could do. > > If you don't trust these users w/ delete/mod access, why do they have it > in the first place? Revoke priviledges in Informix, and they're locked > out no matter what client (ODBC or otherwise) they use. > > Have I missed something? > > Jay >