Inter-Server Permissions

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

> 'Client host or user (xxx@yyy) is not trusted by the server.' Who created the view? maybe that user is not trusted??? Superboer. On 27 sep, 18:44, Keith Simmons <smile...@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