Re: Tips on implementing trusted clients

On Fri, 17 Jul 1998 05:43:08 GMT, granta@nospam.student.canberra.edu.au (Fuzzy) wrote: >Hi people > >We are about to make some changes to our application to allow for >trusted connections to Informix ODS and OWS. Does anyone out there >have any tips, tricks or traps they know of from their own >experiences? Depends what you mean by trusted. Also depends how you have written you applications and in what language. If they are 4GL applications runing on the same server as the database you should be able to use nothing but the access control mechanisms of the engine - username, password, connection and individual rights on each table/column. Using roles to do the last is often a good idea. If you are talking about client/server applications with clients on MS Windows there are many new problems. The best start is to look at the OpenLink ODBC/JDBC drivers for their solutions. If that isn't enough you may have to use only stored procedures for all database updates. That's very hard, and not something I would want to implement, but may be required in some cases. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)