Re: read only views

Posted in 2001

Tsutomu Ogiwara — Wed, 07 Feb 2001 09:41:38 +0900 — source: Informix-list mailing list archive (1991-1998)

At 12:56 01/02/06 +0000, Peter Morris wrote: Hi Peter. How about this ? Please run following SQL. revoke all on custview to public; grant select on custview to public; Regards. >is it possible to create read only views? > >what is the syntax? > > >-- > ______________________ >/_____________________(_) >| _____________________ email to >| | |__________________(_) Peter_Morris_1 >| |/____________________ at Hotmail dot com >|_____________________(_) > > -- Tsutomu Ogiwara Technical Group & Red Brick Group, Informix Sales Promotion Dept ITOCHU TECHNO-SCIENCE Corporation YASUKUNI KUDAN-MINAMI BLDG., 2-3-14, KUDAN-MINAMI, CHIYODA-KU TOKYO,1 02-0074 JAPAN Phone:+81-3-5212-4891 Fax:+81-3-5212-4889 E-mail:Tsutomu.Ogiwara@ctc-g.co.jp / tsutoo@my-deja.com