OK. I tested and it worked.
SS should have "CREATE ANY TRIGGER" priv, because SS is creating a trigger on a table that he has not owned.
You do not need use :NEW.tablename.columnname.
Just use :NEW.COLUMNAME.
Tamil
|
Results 1 to 6 of 6
Thread: Trigger ProblemThreaded View
|
Click Here to Expand Forum to Full Width |