Re: I-Star and views

->From: M22367@mwvm.mitre.org ->Subject: I-Star and views ->Date: Thu, 18 Feb 1993 14:16:02 GMT ->Reply-To: M22367@mwvm.mitre.org ->Organization: The MITRE Corporation, McLean VA 22102 -> ->We are trying to use I-star to make a useable view of a remote Informix ->database. The view has been created but only the view *owner* can use it. ->We have contacted Informix tech support to no avail. -> ->If you have successfully used I-star to make a view of a remote database, ->please let me know what we need to do to get this thing to work. We are ->running Informix 5.0 on an RS-6000 running AIX 3.2.2. -> ->- Mike Waters -> One can GRANT permissions to views, as well as to tables. I am not sure how this would interact with I-star and a view on a remote table; but it is simple to test. Have the owner grant select on the view to public, then retry your queries; grant update and try your updates, etc. Regards, Alan +------------------------------+---------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Martin Marietta, LSC | ( Please note: My opinions do not ) | | P.O. Box 179, M/S 5422 | ( represent official Martin policy. ) | | Denver, Colorado 80201-0179 | Voice: 303-977-9998 | +------------------------------+---------------------------------------+