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 privilege on the target table.
• Event types that define a table trigger are instance and statement events.