CREATE TABLE TABLE1(
SET TERM ^ ;
CREATE TRIGGER TABLE1_BIU FOR TABLE1
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
new.FIELD1 = 0;
SET TERM ; ^
GRANT UPDATE (FIELD1, FIELD2) ON TABLE1 TO TRIGGER TABLE1_BIU;
ALTER TABLE TABLE1 ALTER COLUMN FIELD2 TO FIELD3;
Then try b/r and get exception: "Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
action cancelled by trigger (1) to preserve data integrity.
could not find column for GRANT"