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.

create table x ( ... ); revoke all on x from public; create role rd_wr; -- read / write role create role rd_only; -- read only role grant rd_only to rd_wr; grant select on table x to rd_only; -- permit read from x grant insert, delete, update on x to rd_wr; -- permit write to x grant connect to rd_wr_user; grant rd_wr to rd_wr_user; grant connect to rd_only_user; grant rd_only to rd_only_user; <Reto.Loser@checkit.ch> ''''' ' ''''''''':8s1620$nn4$1@nnrp1.deja.com... > 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.