Re: Inter-Server Permissions

One thing to try, in the view, if you have the remote table qualified with its owner, remove that, if you don't, try qualifying it and see what happens. Only thing I've got for you. 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 Wed, Sep 28, 2011 at 9:05 AM, Art Kagel <art.kagel@gmail.com> wrote: > Looks right to me! Something is hinkey. Open a case I think 'cause this > should just work. > > > 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 Wed, Sep 28, 2011 at 8:50 AM, Keith Simmons <smiley73@gmail.com> wrote: > >> On 28 September 2011 12:24, Art Kagel <art.kagel@gmail.com> wrote: >> > 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 >> > >> > >> Art >> >> As below >> >> User Select Update Insert Delete Index Alter >> informix All All Yes Yes No >> No >> public All All Yes Yes >> No No >> >> Keith >> > >