Re: Question on use of CLI and table privileges

thorner@hboc.com wrote: > Problem: > > Need to restrict user access when using ODBC to read-only, since this is > an accounting system and the auditors demand that all updates be done > through the 4GL front end. Any ideas on how I can restrict ODBC access > to RO, while maintaining the RW privilege for 4GL users? If you're tied to CLI, then I can't do anything. However, if you get a free-standing ODBC driver (not related to Informix), then you might have some hope. Security is not a feature of the ODBC spec per se. However, in response to situations such as yours, various ODBC vendors have implemented security solutions, as we have. Using our ODBC driver, you can set all SQL select (select, insert, update etc) to all db's to all tables by Unix user and also Windows application. Try our JDBC/ODBC driver: SCO SQL-Retriever. Take a look at http://www.vision.sco.com/products/sqlretriever/ for more info and a downloadble eval Allan Gould (allang@sco.com)