Can I create a trigger on a synonym ?
579029Jul 3 2007 — edited Jul 4 2007Hi
There are two user accounts (schema). When one user access other user's table, SQL like
Select * from user2.table
If create a synonym
create synonym table for user2.table;
Then
select * from table
is working.
My question is can I create trigger by this synonym? I tried
"Create trigger on table" but trigger can not created.
Trigger should created on user2's table.
Thanks!