Who Can Create a DML Trigger?
DML triggers can be created by:
-
The owner of the table (or view)
-
Users with — for a table — the
ALTER ANY TABLE
, or — for a view —ALTER ANY VIEW
privilege
DML triggers can be created by:
The owner of the table (or view)
Users with — for a table — the ALTER ANY TABLE
, or — for a view — ALTER ANY VIEW
privilege
Firebird supports two forms of declaration for relation triggers:
The legacy syntax
The SQL standard-compliant form (recommended)
A relation trigger specifies — among other things — a phase and one or more events.