Problems with distributes tables
Posted in 1992
I have a problem trying to access a view which selects from tables in a remote hosts. The scenario: ------------ At machine host_1: For database db_A user dba_B has select permission with grant option on tab_x and tab_y user usr_C has select permission on the same tables Both users have "host_2.mrec.ar" in their .rhosts At machine host_2: For database db_B user dba_B is the dba user usr_C has connect permission user dba_B creates a view the_view as select x.*, y.* from db_A@host_1:tab_x x, db_A@hosts_1:tab_y y where x.c1 = y.c1 and gives select permission to public Both users have "host_1.mrec.ar" in their .rhosts The problem ----------- When I am user dba_B on host_2, I can select from the view OK but ... when I am user usr_C on host_2, I get the message: 918 Unexpected data received from remote system the manual says "... run your network diagnostics ..." I did, and everything seems to be right. and ... a core file corresponding to sqlturbo appears in the home directory of usr_C on host_1 Any ideas ? --- Maria Alejandra Perez Weiss alex@lucas.mrec.ar PNUD - Min.Rel.Ext. y Culto alex%lucas.mrec.ar@uunet.uu.net Buenos Aires - Argentina ...!uunet!atina!lucas!alex