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)