Question on use of CLI and table privileges

Got a question about CLI and user access privileges - hope someone can help... Background: Users have ID's on UNIX box with Informix 5.04 online engine and have RW privileges for all tables ("public"). They access the data with an accounting system written in 4GL using a character based front-end. Users want ODBC access to the database on their PC's, using the Informix-CLI product. They want to use this to look at the data with spreadsheets and other products such as Crystal Reports. 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? Other Information: There are 600 tables and 6000 users on this system. The idea I have come up with so far is to restrict ODBC access using /etc/hosts.equiv to a few users. Give these users RO access, and keep all other users at RW access. However, this means setting specific tables access privileges for all users for all tables, a maintenance nightmare at best. Any other ideas are most welcome. Thanks in advance!! Tom Horner -- Informix DBA HBO and Company Atlanta, GA -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet