RE: READ ONLY Access to Informix DB??

You can do this by using REVOKE to remove all default privilege and using GRANT to assign a CONNECT and SELECT privileges only to specific users. You may want to create ROLES to make it easier to maintain and administer these users. Don -----Original Message----- From: Reto.Loser@checkit.ch [mailto:Reto.Loser@checkit.ch] Sent: Wednesday, October 11, 2000 3:49 AM To: informix-list@iiug.org Subject: READ ONLY Access to Informix DB?? Hi all, I'm new to informix and would like to know, if there is a simple way to access a Informix DB with READ ONLY priviliges. What we would like to to is, setting up an account which has only READ permissons to the DB. Does anyone know if this is supportet by Informix? How long does it take to install (is it just defining a new user and setting up the DB-Rights)? Or do I have to define separtly VIEW's with read only access? Any comments to my questions are welcome!! Regards Reto Loser Sent via Deja.com http://www.deja.com/ Before you buy.