Thanks Jean-Pierre,

That would also showup in VDBA as a different schema ?? I had that checked and there is only one. Within the application users log on as the same user 'res' and only use those tables.

Sean Hennessy
Don't Panic Business Management


Jean-Pierre Zuate, La Fage Conseil wrote:
Hello,

Could this be like that because this user in this database own a table with the same name ?

You can check this by running :
SELECT table_name, table_owner FROM iitables WHERE table_name = 'the table' Check it on every DB you have. If in the incrimined node you have 2 rows, then you have the solution ...

Hope this help,
--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://lafageconseil.fr/

2007/10/29, Sean Hennessy <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>:

    Hi All,

    Hopfully this list isn't quite dead...

    I have a problem with one client in a network of about 5 seeing
    slightly
    different rows to everyone else.
    If the user logs onto another system and starts the application
    everything is ok, but on one particular
    system, user cannot see all rows added by others, and all others
    cannot
    see all rows added by this user.

    this started on Friday.  one database only, one node defined, one
    schema
    only.

    Any hints ??????  I'm stuffed.

    Sean Hennessy
    Don't Panic Business Management
    _______________________________________________
    Users mailing list
    [email protected] <mailto:[email protected]>
    http://lists.ingres.com/mailman/listinfo/users




------------------------------------------------------------------------

_______________________________________________
Users mailing list
[email protected]
http://lists.ingres.com/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.ingres.com/mailman/listinfo/users

Reply via email to