Re: Inter-Server Permissions

Posted in 2011

Art Kagel — Wed, 28 Sep 2011 09:05:10 -0400 — source: Usenet: comp.databases.informix

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 >