Accesing a table of another schema via trigger doesn't work
582007Mar 12 2008 — edited Mar 12 2008Hi all.
I have user1 and user2. User1 has a trigger that when an insert occurs in user1.table1 does an insert in user2.table. But when I create the trigger I get:
Número de Línea = 6 Número de Columna = 42 Texto de Error = PL/SQL: ORA-00942: table or view does not exist
And user1 has a private synonym, select and insert grants to user2 table. How can I do the insert via the trigger? I tried calling a procedure from the trigger but in the procedure I get the same error.
Thanks in advance.