Creation should include
- reviewing system events (e.g., LOGON, LOGOFF, SERVERERROR)
- writing the trigger:
- Trigger name—Defining the trigger name
- Timing—Determining when the trigger will execute; before, after, or instead of
- Event—Determining the system event and the ON DATABASE or ON SCHEMA
- Trigger body—Writing a PL/SQL block to include the actions of the trigger