Re: Inter-Server Permissions

What are the ownership and privileges on the view? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 27, 2011 at 12:44 PM, Keith Simmons <smiley73@gmail.com> wrote: > Here's strange one !! > IDS10 on Solaris 8 and IDS9.4 on AIX 5.3 (I know all about old > versions and paucity of support). > > On the Sol server I have a synonym pointing to a table on the AIX > server, also a view pointing to > the same table (one of our MI software packages evidently doesn't > understand synonyms !!). > > Connecting to the Sol server as informix I can select from the base > table (instance@server:table) > from the synonym and from the view, however when using the query user > I can select from the > base table and from the synonym but NOT from the view !! I get error : > 'Client host or user (xxx@yyy) is not trusted by the server.' > > Both informix and public have the same permissions on both view and > synonym and (obviously) > there is an adequate trust relationship between the servers else the > base table select would not > work. > > Any suggestions, hair is beginning to be torn !! > > Keith > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >