Trigger Type
User Trigger
- A trigger relevant to a specific user of the database is called a user trigger.
- A user trigger has no event target and is executed only by the owner of the trigger (the user who created the trigger).
- Event types that define a user trigger are COMMIT and ROLLBACK.
-
Table Trigger
- A trigger that has a table as the event target is called a table trigger (class trigger).
- A table trigger can be seen by all users who have the SELECT authorization on a target table.
- Event types that define a table trigger are instance and statement events.