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

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 (AT) gmail (DOT) com> wrote:

On 28 September 2011 12:24, Art Kagel <art.kagel (AT) gmail (DOT) com> wrote:

As below

User Select Update Insert Delete Index Alter
informix All All Yes Yes No No
public All All Yes Yes
No No

Keith

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 (AT) gmail (DOT) com> wrote:

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 (AT) gmail (DOT) 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 (AT) gmail (DOT) com> wrote:



--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Who created the view? maybe that user is not trusted???


Superboer.

On 27 sep, 18:44, Keith Simmons <smile... (AT) gmail (DOT) com> wrote:

On 29 September 2011 01:32, Fernando Nunes <domusonline (AT) gmail (DOT) com> wrote:
No functions involved will try a test case on Monday.

Keith

On 29 September 2011 01:32, Fernando Nunes <domusonline (AT) gmail (DOT) com> wrote:
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