Re: Inter-Server Permissions

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