Re: Database Security with ODBC users...

> I have an order entry application that has been written with the Fourgen > Case Tools and Informix 5.01 SE on a RS/6000. I would like to use a > third party product for simple ad-hoc reporting like MS Access using > ODBC and INET. Is there a way to protect the database from any > unfortunate updates while using MS Access? I will be using the same > user-id for the order entry application as well as MS Access. Deny update permissions to the tables, and have the application do its updates via Stored Procedures. Check the section on SPL in the "Guide to SQL: Tutorial" - it's one of the things SPL was designed to allow you to do. Going through a stored procedure bypasses the table-level restriction. Could be a bit tedious modifying the Fourgen code though. Alternatively, use a product like Informix-Viewpoint which was specifically designed for end user querying. It would almost certainly be easier to set up and quicker to execute than going through ODBC. akent@cix.compulink.co.uk (Andy Kent) -------------------------------------