How to limit database access with dbaccess and/or isql

Posted in 1995

Ben Van Truong — Fri, 22 Sep 1995 18:53:42 GMT — source: Informix-list mailing list archive (1991-1998)

We are running mission critical application using On-line Informix 5.04. The database user interface front-end is provided for all business functions. However, for trouble shooting purposes, some developers need to exam the data using either dbaccess or isql. To ensure no damage can be made to database, I would like to restrict some SQL verbs such as INSERT, DELETE, DROP, etc. while they're using the dbaccess and isql tools. What is the best way to approach this problem?. Is there any such tool available in the market place?. Your opinion/solution/suggestion is appreciated. Thanks.