Re: Inter-Server Permissions

On 29 September 2011 01:32, Fernando Nunes <domusonline@gmail.com> wrote: > 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... > To all my respondants. My deepest apologies, my bad. I was creating the view over the fight table but in the wrong server and instance (only one character different, so much for naming standards !!). Dropped and re-created the view to the correct server and all is OK !! Thanks and apologies once more. Keith