Re: ODS7.23, NT,-How to allow ODBC read only access to selective tables.

Roger It's a shame you're using Informix on NT otherwise you could use the Security Manager in our ODBC driver (see http://www.sco.com/support/ciservices/sqlr/docs/secman.html). However, you should be able to find an ODBC driver for Informix/NT that does have an additional security module to do exactly what you want. In this way, you can restrict the access at the ODBC level and won't have to touch the database. Allan Gould (allang at sco dot com) (Please remove anti-spam measures if replying) SCO SQL-Retriever. http://www.sco.com/vision/products/sqlretriever/ Roger Evans wrote: > > Hi, > We use informix on NT as the database for our Baan ERP system. Apart from > backing things up using an ontape command we are fairly removed from getting > our hands dirty using Informix directly, and have very little knowledge of > Informix. We do everything through 4GL's, VB etc via ODBC. > Our American parent company has asked for read-only access to a few of our > Baan tables (8 or 10 from about 12,500 - Each Baan company creates 2500 > tables and we have 5 companies) > The Baan tables seem to have Public with ALL permissions. > I was told it was possible to restrict the tables and only allow read only > using the GRANT PERMISSION statement, but have not had too much luck so far. > I don't want to start removing permissions from Baan tables if possible, > because the product is flakey enough as it is. > Is there any way I can create some views of the specific tables for my > American colleagues? > Please keep the answer simple, you're dealing with a complete novice!! > > Thanks in anticipation > Roger Evans