echo "create database a in dev1;
grant connect  to test;
create table t1 (f int);
"|dbaccess sysmaster

echo "create database b in dev1;
create table tb1 (f int);
create table tb2 (f int);
create PROCEDURE test();
 insert into  tb2  values (1);
END PROCEDURE;

database a;
create trigger tr1 insert on t1 referencing new as inserted
for each row
 ( insert into  b:tb1  values (1));

database b;

create trigger tr2 insert on tb1 referencing new as inserted         
for each row
 ( insert into  tb2  values (111));
"|dbaccess sysmaster

echo "grant insert on t1  to test"|dbaccess a

коннектимся test\test@a insert into t1 values ( 100 );

echo "select * from tb2;"|dbaccess b
Database selected.
          f
         111 
 1  row(s) retrieved.
Database closed.

IBM Informix Dynamic Server Version  10 . 00 .UC3

echo "drop trigger tr2;
create trigger tr2 insert on tb1 referencing new as inserted          
for each row
 ( execute procedure test());         
"|dbaccess b

коннектимся test\test@a insert into t1 values ( 100 );


echo "select * from tb2;"|dbaccess b
Database selected.
          f
         111 
           1 
 2  row(s) retrieved.
Database closed.

echo "connect to 'a' USER test; insert into t1 values (100);"|dbaccess sysmaster
Database selected.

   201 : A syntax error has occurred.
Error in line  1 
Near character position  24 

   206 : The specified table (t1) is not in the database.
   111 : ISAM error:  no record found.
Error in line  1 
Near character position  42 

Database closed.



echo "connect to 'a' USER test fsdfsgdgfgh; insert into t1 values (100);"|dbaccess sysmaster
Database selected.
   ENTER PASSWORD:
Disconnected.
Connected.
 1  row(s) inserted.
Disconnected.