Re: How to limit database access with dbaccess and/or isql

Best thing is to restrict theire access to only select of all data available. This means they can not execute programs and sql with update. Yet if they are developers they should not be running this function after it has been released to the user's. The level of access to the DB only needs to be connect and then select to all tables. I do it this to the generic ID of "public" provide by Informix. Otherwise you will have to maintain DB and table grant statements. On Fri, 22 Sep 1995, Ben Van Truong wrote: } 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. } }