Re: Inter-Server Permissions

The view includes just one table? Does it include any function? Could you create a simple test case, eventually based on stores database? On Tue, Sep 27, 2011 at 5: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 > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...