Re: EXCEL spreadsheet to INFORMIX through ODBC

AFAIK you need to revoke update/delete permissions for the ODBC user. Bottom line, if the user has odbc access to your database then they can submit any valid SQL statement, it is up to the DBA to prevent the engine from allowing it to execute. N wrote: > > Hi all, > I set up an Excel spreadsheet to our production database > through ODBC driver to get a report. Everything was working > fine, and life was good until I found a little problem with the > SQL tool in Excel. Normally, to get a report Excel will write > a select statement according to criterias that the users input/ > choose. It also allows anyone to Edit the select statement it > writes in a little box. What I did was changing that select > statement to delete/update statement. And it ran. What > surprised me was that it actually ran the statement against > the database and delete/update tables accordingly. This is > not what we want. I have not been able to find any options > to turn this thing off so that the user cannot edit the generated > select SQL. I know all the permissions the user has are > defined through the username that is defined in ODBC. > We don't want to change all the user permissions on the > database side. Is there any other way ? > > MS Excel 2000 > IDS 9.30 UC1 > Dynix/ptx V4.5.3 > > Thanks > N. -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #