Re: GRANT on VIEW

Marvin wrote: > > Rudy Fernandes wrote: > > > > Who are you logged in as when you run into the error? > > > > As "informix" or the owner of the view, you should be able to > > > > grant all on <view> to public;> > > > Rudy > > > > Marvin wrote: > > > > > Maybe I don't understand what multi-table means, but in my VIEW, I have > > > only one table with 6 fields. That does not sound like a multi-table view, no. > I don't think, If you create view under > > > one > > > username, the others can reach it. Perhaps I should grant view as a > > > public, > > > but I don't know how. My goal is getting information from that VIEW from > > > two different login names. > > > > > > Regards > > > Alex > > I get the same message: > > > grant all on mytable to public;> > 302: No GRANT option or illegal option on multi-table view. > Error in line 1> Near character position 28 Try: GRANT ALL ON myview TO PUBLIC AS <owner of view> Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+